InnoDB行锁,MyISAM表锁,真是没有十全十美的事情啊。
备份 MyISAM 表:
/usr/local/mysql/bin/mysqldump -ubak -p741852
–default-character-set=utf8 –opt –extended-insert=false –triggers
-R –hex-blob -x db_name > db_name.sql
备份 Innodb 表:
/usr/local/mysql/bin/mysqldump -ubak -p741852 –default
-character-set=utf8 –opt –extended-insert=false –triggers -R
–hex-blob –single-transaction db_name > db_name.sql
2014-07-13 16:31:57