Wow Eric you are amazing! I will give this a try tomorrow and let you know how it goes.
Just a quick question though, will it wait for the mysqldump to finish before going on to the next step? (Which you have as sleep 3s.) It's just that they take about 30 minutes to complete for one of my databases!
Also, would it be possible to add a further step to gzip the db?
And this is wishful thinking, but how easy would it be to make the script back up once a day, but only keep backups for the last 7 days, then 1 from a week ago and one from a month ago, then another from 3 months ago. I guess that's pushing it a bit eh? :lol:
Thanks again for your help, much appreciated
