Where does MySQL store database files?

Question

I have a remote wamp server and now I need my recovery database. How can I complete this process?

Answer 1

In any case, you may know this:

mysql> select @@datadir; +----------------------------------------------------------------+ | @@datadir | +----------------------------------------------------------------+ | D:\Documents and Settings\b394382\My Documents\MySQL_5_1\data\ | +----------------------------------------------------------------+ 1 row in set (0.00 sec) 

Thanks to Barry Galbraith from the MySql forum http://forums.mysql.com/read.php?10,379153,379167#msg-379167

Answer 2

WAMP stores the db data in WAMP\bin\mysql\mysql(version)\data . Where the WAMP folder itself depends on where you installed it (on xp, I believe that it is located directly in the main drive, for example c:\WAMP\...

If you deleted this folder or deleted this folder, if you did not back up the database before the deletion, you might be out of luck.

If you made a backup, although phpmyadmin, then log in and go to the import tab and go to the backup file.

Answer 3

Check your my.cnf file in the MySQL program directory, find

 [mysqld] datadir= 

datadir is where your MySQL database is stored.

Answer 4

another way from MySQL Workbench: