您也可以使用MySQL管理员中的恢复菜单。你只需要打开备份文件，然后点击还原按钮。

假设你已经创建了空白数据库，你也可以像这样从命令行恢复数据库:

mysql databasename < backup.sql

我按照下面的步骤来做。

Open MySQL Administrator and connect to server Select "Catalogs" on the left Right click in the lower-left box and choose "Create New Schema" MySQL Administrator http://img204.imageshack.us/img204/7528/adminsx9.th.gif enlarge image Name the new schema (example: "dbn") MySQL New Schema http://img262.imageshack.us/img262/4374/newwa4.th.gif enlarge image Open Windows Command Prompt (cmd) Windows Command Prompt http://img206.imageshack.us/img206/941/startef7.th.gif enlarge image Change directory to MySQL installation folder Execute command: mysql -u root -p dbn < C:\dbn_20080912.dump …where "root" is the name of the user, "dbn" is the database name, and "C:\dbn_20080912.dump" is the path/filename of the mysqldump .dump file MySQL dump restore command line http://img388.imageshack.us/img388/2489/cmdjx0.th.gif enlarge image Enjoy!

如果你已经在mysql提示，并假设你的转储文件转储。Sql，那么我们还可以使用如下命令来恢复转储

mysql> \. dump.sql

如果您的转储大小较大，请将max_allowed_packet值设置为更高。设置此值将帮助您更快地恢复转储。

一行命令从mysqldump恢复生成的SQL

mysql -u <username> -p<password> -e "source <path to sql file>;"

本地mysql:

mysql -u root --password=YOUR_PASS --database=YOUR_DB < ./dump.sql 

如果你使用docker:

docker exec -i DOCKER_NAME mysql -u root --password=YOUR_PASS --database=YOUR_DB < ./dump.sql