MySQL在哪里存储数据库文件?

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

我已经卸载了wamp服务器，现在需要恢复数据库。我怎么做这个过程?

5 个解决方案

#1

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

感谢来自MySql论坛的Barry Galbraith, http://forums.mysql.com/read.php?

#2

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\...

WAMP存储在WAMP\bin\mysql\mysql(版本)\数据下的db数据。WAMP文件夹本身的位置取决于您将它安装到何处(在xp上，我认为它直接位于主驱动器中，例如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.

如果你删除了那个文件夹，或者卸载掉了那个文件夹，如果你在卸载之前没有做一个DB备份，那么你可能就没那么幸运了。

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

如果您确实通过phpmyadmin进行了备份，那么请登录并单击import选项卡，然后浏览到备份文件。

#3

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

在MySQL程序目录中检查my.cnf文件，查找

[mysqld]
datadir=

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

datadir是存储MySQL数据库的位置。

#4

another way from MySQL Workbench:

MySQL Workbench的另一种方式:

#5

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

对于WampServer，单击其托盘图标，然后在弹出式级联菜单中选择

MySQL | MySQL settings | datadir

#1