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

mysql database data-migration
Arif picture Arif · Mar 11, 2012 · Viewed 191.2k times · Source

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?

Answer

Alfonse picture Alfonse · Feb 6, 2015

For Mac, your database files are located at: 

/Applications/XAMPP/xamppfiles/var/mysql

You might need admin permissions to access or delete your files.

Related questions

How can I transfer data between 2 MySQL databases?

I want to do that using a code and not using a tool like "MySQL Migration Toolkit". The easiest way I know is to open a connection (using MySQL connectors) to DB1 and read its data. Open connection to DB2 …

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
How do I quickly rename a MySQL database (change schema name)?

The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does …

Read More