Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Auto backup via webpage

[gbjbaanb]

Hi.

I have a shared host, on which I run dotProject (PHP with MySQL backend). Now, I want to back up the entire site daily.

I can FTP the files from the server to my (windows) client easily (I use syncer which ftps changed files only - it works really well), but the only way I have of backing up the sql data is via the dotProject webpage by clicking the link and downloading the file it creates.

Does anyone have any ideas how I can automate this process? Alternatively, any way of getting sql data out of a MySql DB, where I do not have shell access, and the DB is not directly accessible over the internet?

thanks.

[amc-james]

you could possibly do a wget via a cronjob or something. If you have phpMyAdmin access, you can back up the database that way too.

[brianoz]

Run mysqldump from crontab into a file:

mysqldump ... | gzip > file.out

Download the file periodically via wget from a local machine.

Cheers!