mysql导出(备份)单张表,mysql备份指定表
- WBOYOriginal
- 2016-06-07 15:52:422169browse
# /usr/local/mysql/bin/mysqldump -uroot -p123456 mydb mytb /opt/mytb.sql 解释: mysqldump 备份命令 -uroot root用户 -p123456 密码为123456 mydb 表所在的数据库mydb mytb 将要导出的表mytb 如果不指定具体表，就导出整个数据库 /opt/mytb.sql 备份到my
# /usr/local/mysql/bin/mysqldump -uroot -p123456 mydb mytb
解释:
mysqldump 备份命令
-uroot root用户
-p123456 密码为123456
mydb 表所在的数据库mydb
mytb 将要导出的表mytb 如果不指定具体表，就导出整个数据库
> /opt/mytb.sql 备份到mytb.sql中
还原：
# /usr/local/mysql/bin/mysql -uroot -p123456 mydb > /opt/mytb.sql
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插入中文乱码问题：Incorrect string value: ‘xA8DxNext article：Nutch2.1+mysql+solr3.6.1+中文网站抓取