MySQL:在同一MySql实例上克隆MySQL数据库 [英] MySQL: Cloning a MySQL database on the same MySql instance
问题描述
我想编写一个脚本,将我的当前数据库 sitedb1
复制到同一mysql数据库实例上的 sitedb2
中.我知道我可以将sitedb1转储到sql脚本中:
I would like to write a script which copies my current database sitedb1
to sitedb2
on the same mysql database instance. I know I can dump the sitedb1 to a sql script:
mysqldump -u root -p sitedb1 >~/db_name.sql
,然后将其导入到 sitedb2
.是否有一种更简单的方法,而无需将第一个数据库转储到sql文件?
and then import it to sitedb2
.
Is there an easier way, without dumping the first database to a sql file?
推荐答案
As the manual says in Copying Databases you can pipe the dump directly into the mysql client:
mysqldump db_name | mysql new_db_name
如果您使用的是MyISAM,则可以复制文件,但我不建议这样做.有点狡猾.
If you're using MyISAM you could copy the files, but I wouldn't recommend it. It's a bit dodgy.
综合了其他各种好答案
mysqldump
和 mysql
命令都接受用于设置连接详细信息的选项(以及更多),例如:
Both mysqldump
and mysql
commands accept options for setting connection details (and much more), like:
mysqldump -u <user name> --password=<pwd> <original db> | mysql -u <user name> -p <new db>
此外,如果新数据库尚不存在,则必须事先创建它(例如,使用 echo"create database new_db_name" | mysql -u< dbuser> -p
).
Also, if the new database is not existing yet, you have to create it beforehand (e.g. with echo "create database new_db_name" | mysql -u <dbuser> -p
).
这篇关于MySQL:在同一MySql实例上克隆MySQL数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!