Home >Database >Mysql Tutorial >我踩了mysqldump的一个地雷_MySQL
我踩了mysqldump的一个地雷_MySQL
- WBOYOriginal
- 2016-06-01 13:17:381041browse
mysqldump
我们先看2种情况：P 1：[ 21:56:33-root@ssdtest:~ ]#mysqldump -S /data/mysql/test_3306/mysql.sock --single-transaction --force --databases tpcc > v1.sql
P 2：
[ 21:56:54-root@ssdtest:~ ]#mysqldump -S /data/mysql/test_3306/mysql.sock --single-transaction --force tpcc > v2.sql
数据库无辜惨遭"恢复出厂设置" :-)线上操作必须列出执行方案，并尽可能评估每个操作背后所潜在的风险。这是DBA的基本职业素养。
Good Luck！
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：MySQLSQL优化：Percona优化器真的好吗？_MySQLNext article：Mysql+Corosync+Pacemaker+DRBD_MySQL