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 ..
Thank you for the excellent details regarding the different available scripts. :)