Mysql database files stored in where?

Today the company to backup the database, I found from the Internet, MySQL database default stored in the C:\Program Files\MySQL\MySQL Server 5.5\data. (data file:. MyD index file: MYI table definition file.: . frm). But when I entered the MyD file is 0kb, but the data in a database. A lot of ah, how can the table structure and data from a backup? (can use tools like phpMyAdmin to manual backup, but I want to use the software automatic backup of the database folder)

Started by Ivan at November 29, 2016 - 3:43 AM

show variables like 'datadir';
Backup or use MYSQLDUMP to backup.

Posted by Nick at December 13, 2016 - 4:06 AM

Only the MYSIAM storage engine is stored in the directory, and INNODB is placed in the ibdata1 file.


Suggest stopping back up the entire dataDir directory specified.

Posted by Louis at December 15, 2016 - 4:55 AM

The 1 copy directly the physical file:
The backup show variables like'datadir'; all files: IDB files, frm files etc.

2.mysqldump exported all the base.

Posted by Darren at December 17, 2016 - 5:36 AM