CODEWITHSUNDEEP
mysqlphpmyadminwamprecover
Ihsanullah khan
Ihsanullah khan

Reputation: 771

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?

Upvotes: 54

Views: 163169

Answers (5)

MarianD
MarianD

Reputation: 14201

For WampServer, click on its tray icon and then in the popup cascading menu select

MySQL | MySQL settings | datadir

MySQL Data Directory

Upvotes: 0

Cryophallion
Cryophallion

Reputation: 704

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

If you deleted that folder, or if the uninstall deleted that folder, if you did not do a DB backup before the uninstall, you may be out of luck.

If you did do a backup though phpmyadmin, then login, and click the import tab, and browse to the backup file.

Upvotes: 27

GorvGoyl
GorvGoyl

Reputation: 49660

another way from MySQL Workbench:

enter image description here

Upvotes: 4

Jorge Nunez Newton
Jorge Nunez Newton

Reputation: 1296

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

Upvotes: 105

Graviton
Graviton

Reputation: 83306

Check your my.cnf file in your MySQL program directory, look for

[mysqld]
datadir=

The datadir is the location where your MySQL database is stored.

Upvotes: 18

Related Questions