Mysql Backup for VPS

Doing some research tonight and finally setup a script to backup all the mysql database on my vps, just to share some of the solution out there

• Mysqldumper – it act like a script which require you to install, work with both php and pear
• Automysqlbackup – a shell script that allow to backup all database, one file with lots of option to customize
• MyCpanelBackup – a desktop program that allow you to backup your database locally
• A Smarter Backup Script – a backup script that sharing among cpanel forum

what i doing now is using Automysqlbackup to backup the database daily then rsync to my backup server, account backup might need some tweak also ..