Menu
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?
299
1 Answer. You will get all databases at the "xampp/var/mysql". You can copy the complete folder to the new setup and it will show you all databases.
To get a list of the tables in a MySQL database, use the mysql client tool to connect to the MySQL server and run the SHOW TABLES command. The optional FULL modifier will show the table type as a second output column.
Step 2: Add Files and Database to XAMPP The first step is to copy the files from (C:\Users\##YOURNAME##\Desktop\Backup\) into your XAMPP htdocs folder, inside of a test folder (C:\xampp\htdocs\test\). With the XAMPP Control Panel open, start Apache and MySQL, then click the Admin tab on MySQL.
phpMyAdmin is just an interface (written in PHP) to communicate with MySQL. If you have installed MySQL on linux, the default data storage directory will be /var/lib/mysql, unless you have configured it manually for some other directory.
For Mac, your database files are located at:
/Applications/XAMPP/xamppfiles/var/mysql You might need admin permissions to access or delete your files.
88
Your database is in this directory:C:\xampp\mysql\data
35
Rather late I know, but you can use SELECT @@datadir to get the information.
Happy file huntin' SO community :)
This is how it looks when ran in phpmyadmin:
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
