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 ..