Search code examples
mysqldatabasedata-migration

What is the exact location of MySQL database tables in XAMPP folder?

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?

Solution

  • 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.