Add “−−lock-tables=false” to your mysqldump command
[server] mysqldump -uUsername -pPassword Database −−lock-tables=false | gzip > backup.bak.sql.gz
source : http://jamielesouef.com/linux/tip-backing-up-a-large-mysql-database-errno-24/
Add “−−lock-tables=false” to your mysqldump command
[server] mysqldump -uUsername -pPassword Database −−lock-tables=false | gzip > backup.bak.sql.gz
source : http://jamielesouef.com/linux/tip-backing-up-a-large-mysql-database-errno-24/
Tags: Backuping MySQL
This entry was posted on Thursday, April 8th, 2010 and is filed under Database, MySQL. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.
Arclite theme by digitalnature | powered by USU Blog | Universitas Sumatera Utara
#1 by emka on April 30th, 2010
| Quote
just a little correction, the correct options is “–lock-tables=false” just like Jamiele’s said.
#2 by didonk on April 30th, 2010
| Quote
Thanks for the correction. It seem that when we need to type double dash, we have to use special character.