Welcome!
Thanks for visiting. If you found this information interesting or useful (or you think I'm dead wrong about something) I'd like to invite you to leave a comment on this post. You can also 
subscribe to my RSS feed or sign up for email updates on the right-hand side of the page.
If you Digg what you StumbleUpon, find my writing del.icio.us, or are one of the Technorati, you know what to do:
Reliable InnoDB hot backups
There are number of blog posts out there that mention --lock-all-tables as a good option to backup MySQL tables with mysqldump - even InnoDB tables. Don’t do that! That option is for MyISAM tables that don’t do transactions. InnoDB has ooey-gooey transactional goodness that will take a consistant backup without locking all your tables and keeping your applications from running in the meantime. Just do your InnoDB hot backups like this:
mysqldump -u USERNAME -p --add-drop-table --add-locks --create-options --disable-keys --extended-insert --quick --set-charset –single-transaction –all-databases | gzip > OUTPUTFILE
Then viola! No nasty table locks!
Related posts:
- Host your own OpenID with phpMyID Just got done setting up my own OpenID server using...
- BackupPC only when mobile device / laptop is plugged in I'm the proud owner of a Nokia N800 Internet Tablet...
- Recovering after (stupidly) running mkswap on my ext3 partition Disclaimer: it's not my fault if you lose all your...
- So, about that “working perfectly” Well, I have to admit that I was blinded by...
- Restoring from backups with F-Spot I recently had to restore from backups on my laptop,...
