MySQL:创建数据库之类的吗? [英] MySQL: Create database like?
问题描述
在MySQL中,我想克隆某些数据库.是否有
In MySQL I want to clone certain databases. Is there such a thing as a
CREATE DATABASE LIKE <template database here>
命令?
我知道,有
command?
I know, there is
CREATE TABLE LIKE
推荐答案
如果要克隆数据库(例如my_database
),则需要运行mysql查询,然后在linux终端中运行命令:
If you want to clone a database, my_database
for example, you'll want to run a mysql query and then run a command in the linux terminal:
mysql> CREATE DATABASE my_database_copy;
linux终端(在具有数据库的机器上):
mysqldump -u username -p my_database | mysql -u username -p my_database_copy
linux terminal (on the machine with the database):
mysqldump -u username -p my_database | mysql -u username -p my_database_copy
从那里您可能会收到2个输入密码:"提示....只需输入密码,按Enter键,然后等待即可:)
From there you'll likely get 2 "Enter password:" prompts....just input your password, press enter, and wait :)
这篇关于MySQL:创建数据库之类的吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!