|
trigatch,
Daily automated full backups of your web content and databases is definitely worth the effort to get going, as you've learned. I think it takes a harsh lesson to fully realize the value in it. (luckily for me, it was an employer's data rather than my own!)
Anyway, you can backup all databases mysqldump via the --all-databases option. Just make sure you login as the mysql root user so that you have read access to every database. Also, pipe your mysqldump results through gzip to save disk space. Usually can compress at least 70%.
As you scale up across multiple servers or are unable to login and manually retrieve your backups off of your production server for a length of time, having automated rsync and mysql replication to another server (from another provider) is well worth the effort. Also consider implementing backup rotations -- e.g. 1 week of dailys, 2 months of weeklies, 1 year of monthlies, or whatever makes sense for you.
|