如何从 mysqldump 恢复转储文件?

How do I restore a dump file from mysqldump?(如何从 mysqldump 恢复转储文件?)
本文介绍了如何从 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 中)和 cdmysql.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 恢复转储文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

相关文档推荐

Can#39;t Create Entity Data Model - using MySql and EF6(无法创建实体数据模型 - 使用 MySql 和 EF6)
MySQL select with CONCAT condition(MySQL选择与CONCAT条件)
Capitalize first letter of each word, in existing table(将现有表格中每个单词的首字母大写)
How to retrieve SQL result column value using column name in Python?(如何在 Python 中使用列名检索 SQL 结果列值?)
Update row with data from another row in the same table(使用同一表中另一行的数据更新行)
Exporting results of a Mysql query to excel?(将 Mysql 查询的结果导出到 excel?)