恢复备份mysql [英] restore backup mysql

问题描述

我在MySQL中有250MB的数据库备份！

I have a backup of my database in mysql of 250MB !!

如何将其还原到另一台服务器上的新数据库中?

How can I restore it in a new database on another server ?

推荐答案

您没有提供有关所使用的操作系统和备份类型的详细信息，但简短的答案是

You are providing no detail on what operating system you're on and what kind of backup you have, but the short answer is

mysql -u username -p -h hostname databasename < dumpfile.sql

其中dumpfile.sql必须是包含SQL语句的文件，例如用mysqldump生成的文件.

where dumpfile.sql needs to be a file containing SQL statements, for example produced with mysqldump.

这篇关于恢复备份mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！