I use a program called mysqldumper
It does auto backups of each database daily and deletes 3 day old ones. It allows you to upload sql files in excess of 50mb (which is the limit for a lot of hosts) and you can also download all backups.
As I said above, I also got hacked and just by resetting the database from the previous backup I lost 0 posts and threads and got my site back up and working within 5 minutes.
Id suggest you do this also, its a brilliant program.
Matt
|