Search code examples
mysqlphpmyadminwamprecover

where does MySQL store database files?

I have uninstall wamp server and now I need my database to restore. How can I do this process?

Solution

  • In any case you can know it: 

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

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