xampp mysql修改数据存放位置,XAMPP文件夹中Mysql数据库表的确切位置是什么？

I have a MySQL database and I want to know the exact location where this data actually stored in the xampp folder, I went to this file location to try to get the information:

xampp -> mysql -> data ->

Here I found a separate folder for each of my databases and within these folders I saw files stored with the .frm format (FRM FILE).

When I copied my desired database with all tables in .frm format and try to use them on another PC, I was given an empty database of the same name.

Where are the data files for the database kept on the local server?

解决方案

I think the matter is your tables engine. I guess you are using InnoDB for your table. So you can not copy files easily to make a copy.

Take a look at these links:

http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html

http://dev.mysql.com/doc/refman/5.0/en/innodb-migration.html

Also I recommend you to use something like phpMyAdmin for creating your backup file and then restore the backup file on the next machine using the same IDE.