我想写一个脚本,它将同一个mysql数据库实例上的当前数据库 sitedb1 复制到 sitedb2 。我知道我可以转储sitedb1到一个sql脚本:
mysqldump -u root -p sitedb1>〜/ db_name.sql,然后将其导入到 sitedb2 。 有一个更简单的方法,没有将第一个数据库转储到sql文件?
解决方案复制数据库,您可以将转储直接导入mysql客户端:
mysqldump db_name | mysql new_db_name如果您使用MyISAM,您可以 但我不会推荐它。
从各种好的其他答案中整合 code> mysqldump 和 mysql 命令接受用于设置连接详细信息(以及更多)的选项,例如:
mysqldump -u< user name> --password =< pwd> < original db> | mysql -u< user name> -p< new db>此外,如果新数据库还不存在,则必须事先创建code> echocreate database new_db_name| mysql -u< dbuser> -p )。
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.sqland 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_nameIf you're using MyISAM you could copy the files, but I wouldn't recommend it. It's a bit dodgy.
Integrated from various good other answers
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>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数据库
发布评论