Read the original article at Ten things to remember about MySQL backups
Hot backups are an excellent way to backup MySQL. They can run without blocking your application, and save tons on restore time. Percona’s xtrabackup tool is a great way to do this. We wrote a how-to on using xtrabackup for hotbackups.
Just because we love hot backups using xtrabackup doesn’t mean mysqldump isn’t useful. Want to load data into Amazon RDS? Want to isolate and load only one schema, or just[Read more...]