mysqldump命令的使用_MySQL
- WBOYOriginal
- 2016-06-01 13:32:181071browse
mysqldump
bitsCN.commysqldump命令的使用
1.导出结构不导出数据
mysqldump -d databasename -uroot -p > xxx.sql
2.导出数据不导出结构
mysqldump -t databasename -uroot -p > xxx.sql
3.导出数据和表结构
mysqldump databasename -uroot -p > xxx.sql
4.导出特定表的结构
mysqldump -uroot -p -Bdatabasename --table 表名 > xxx.sql
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导出到hdfs中_MySQLNext article：Ubuntu Server使用automysqlbackup脚本_MySQL