Home >Database >Mysql Tutorial >mysql将数据库中表导入另一个数据库_MySQL
mysql将数据库中表导入另一个数据库_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:36:021532browse
bitsCN.com
mysql将数据库中表导入另一个数据库
1、先备份
mysqldump -uxxxx -pxxxx --opt dbname tablename > filename.sql
2、拷贝备份出来的文件filename.sql到目的机器
3、导入数据(覆盖)
mysql -uxxxx -pxxxx dbname
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysql压力测试shell脚本_MySQLNext article：MySQL慢查询专题_MySQL