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?