Backup my db

[scialom]

Hi,

My db is too important to count on my hosting backup.

I want to set a daily backup to mysql and save it on my computer. The problem is that I can't connect form my local machine to the db.

any ideas how can I do it?

Thanks,
Assaf

[jerdo]

Since you can't connect to the db from your local machine you might just want to setup a cron job that copies the db files to a certain directory on the server each night (assuming it is a *nix server and not windows). Then setup a cron on your local computer to scp (or ftp if you don't have scp access) the files to your local machine. For more information on cron and scp just google.