Read the original article at Ten things to remember about MySQL backups
- Use Hot 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.
Use Logical BackupsJust 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 one table? All these great uses make mysqldump indispensable. Use it in …
[Read more]