\n
mysqldump\u5907\u4efd<\/h3>\n
\u6211\u770b\u4e86mysqldump\u4e4b\u540e\uff0c\u81ea\u5df1\u603b\u7ed3\u4e86\u4e0b\uff0c\u5982\u679c\u8981\u4e00\u81f4\u6027\u5907\u4efd\u7684\u8bdd\uff0c\u800c\u4e14\u6570\u636e\u5e93\u4e0d\u662f\u7279\u522b\u5927\u3002\u5927\u5bb6\u770b\u770b\u8fd9\u6837\u5b50\u662f\u4e0d\u662f\u5c31\u53ef\u4ee5\u4e86\uff1f\u53ef\u4ee5\u7684\u8bdd \u5c31\u4ee5\u540e\u6309\u8fd9\u4e2a\u6765\u4e86\u3002<\/p>
1 \u5907\u4efd\u5355\u4e2amyisam\u8868<\/p>
mysqldump --lock-tables --master-data=2 test tablename >backup.sql<\/p>
2 \u5907\u4efd\u5355\u4e2ainnodb\u8868<\/p>
mysqldump --single-transacation --master-data=2 test tablename > backup.sql
<\/p>
3 \u5907\u4efd\u6570\u636e\u5e93\uff0c\u91cc\u9762\u53ea\u6709myisam\u8868<\/p>
mysqldump --lock-all-tables --master-data=2 --databases test1 > backup.sql
<\/p>
4 \u5907\u4efd\u6570\u636e\u5e93\uff0c\u91cc\u9762\u53ea\u6709innodb\u8868<\/p>
mysqldump --single-transacation --master-data=2 --databases test1 > backup.sql
<\/p>
5\u5907\u4efd\u6570\u636e\u5e93\u542b\u6709myisam\u548cinnodb\u7684\u8868<\/p>
mysqldump --lock-all-tables --master-data=2 --databases test1 > backup.sql<\/p><\/p>\n <\/div>\n