Have 10 dynamic sites. How to regularly backup?

[sodani]

I have about 10 websites on a godaddy server with plesk 7.5 as the control panel. The sites are all php/mysql based. Can anyone recommend an easy way for me to back up these sites on a regular basis (say once a week) and backed up on my local machine?

I used to just make sure I had the files stored locally and would export the mysql file weekly and store it on my local machine. However, there's got to be an easier way to do this.

[Swanny007]

What I've done is setup a nightly cron job to dump the databases to gzipped files. Then I have a script on my local machine that runs an hour later to connect via ftp and grab all the .gz files. Google "ftp batch" for help with that.

It works very well, it provides a nightly backup of every database I have for ~8 sites. Then once every 6 months I burn it to disc ;-) I really should be burning a copy monthly.