For MySQL backup different DBA, have different preferences!
Let me first enumerate the following methods:
1. Use the MySQL automatic Dump tool, with the shell and then crontab execution;
2.XtraBackup (These years compared to the fire bar)
Description: http://www.percona.com/doc/percona-xtrabackup/intro.html
Installation: http://www.percona.com/doc/percona-xtrabackup/installation/yum_repo.html
Note: Both InnoDB and MyISAM hot spares are supported. MyISAM need to lock the table.
3.automysqlbackup
Download link HTTP://SOURCEFORGE.NET/PROJECTS/AUTOMYSQLBACKUP/?SOURCE=DLP
A simple, easy-to-use tool that backs up MySQL databases every day, every week, every month. Encryption is supported.
The ability to automatically delete obsolete backup packages.
The biggest purpose of the backup is to recover, so no matter what method you use, I personally recommend that it is important to perform the recovery regularly!
MySQL Backup method Summary