如何从 mysqldump 恢复转储文件? [英] How do I restore a dump file from mysqldump?

问题描述

我得到了一个 MySQL 数据库文件，我需要将其恢复为 Windows Server 2008 计算机上的数据库.

I was given a MySQL database file that I need to restore as a database on my Windows Server 2008 machine.

我尝试使用 MySQL Administrator，但出现以下错误:

I tried using MySQL Administrator, but I got the following error:

所选文件是由mysqldump 并且无法通过以下方式恢复这个应用程序.

The selected file was generated by mysqldump and cannot be restored by this application.

我如何让它工作?

推荐答案

它应该像运行这个一样简单:

It should be as simple as running this:

mysql -u <user> -p < db_backup.dump

如果转储是单个数据库，您可能需要在文件顶部添加一行:

If the dump is of a single database you may have to add a line at the top of the file:

USE <database-name-here>;

如果它是许多数据库的转储，那么 use 语句已经在那里了.

If it was a dump of many databases, the use statements are already in there.

要运行这些命令，请打开命令提示符(在 Windows 中)和 cd 到 mysql.exe 可执行文件所在的目录(您可能需要四处看看有点为它，这将取决于您如何安装 mysql，即独立或作为 WAMP 等软件包的一部分).进入该目录后，您应该可以像上面一样输入命令.

To run these commands, open up a command prompt (in Windows) and cd to the directory where the mysql.exe executable is (you may have to look around a bit for it, it'll depend on how you installed mysql, i.e. standalone or as part of a package like WAMP). Once you're in that directory, you should be able to just type the command as I have it above.

这篇关于如何从 mysqldump 恢复转储文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！