MySQL在哪里存储数据库文件?
我已经卸载了 wamp 服务器,现在我需要恢复我的数据库。我怎样才能完成这个过程?
I have uninstall wamp server and now I need my database to restore. How can I do this process?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
无论如何,您都可以知道它:
感谢 MySql 论坛的 Barry Galbraith http://forums.mysql.com/read.php?10,379153,379167#msg-379167
In any case you can know it:
Thanks Barry Galbraith from the MySql Forum http://forums.mysql.com/read.php?10,379153,379167#msg-379167
WAMP 将数据库数据存储在
WAMP\bin\mysql\mysql(version)\data
下。 WAMP 文件夹本身的位置取决于您将其安装到的位置(在 xp 上,我相信它直接位于主驱动器中,例如c:\WAMP\...
如果您删除了该文件夹,或者如果卸载删除了该文件夹,如果您在卸载之前没有进行数据库备份,那么您可能会运气不佳。
如果您确实通过 phpmyadmin 进行了备份,则登录并单击导入选项卡,然后浏览到备份。文件。
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 examplec:\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.
检查 MySQL 程序目录中的
my.cnf
文件,查找datadir
是存储 MySQL 数据库的位置。Check your
my.cnf
file in your MySQL program directory, look forThe
datadir
is the location where your MySQL database is stored.MySQL Workbench 的另一种方式:
another way from MySQL Workbench:
对于 WampServer,单击其托盘图标,然后在弹出的级联菜单中选择
For WampServer, click on its tray icon and then in the popup cascading menu select