Fine, I think perhaps this would work then. Install this on a PC or Server in your studio and automate it using either CRON on Unix or Task Scheduler on Windows.
// define some variables
$local_file = 'my_safe_storage/db_dump.sql';
$server_file = 'db_dump.sql';
// connect to the FTP server
$conn_id = ftp_connect($ftp_server);
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);
// try to download
if (ftp_get($conn_id, $local_file, $server_file, FTP_BINARY)) {
echo "Successfully written to $local_file\n";
} else {
echo "There was a problem\n";
}
// close the connection
ftp_close($conn_id);
Have a look on the internet for running the script from the command line. The main thing is that you use php.exe in the program folder.
That's me two pennance worth. If you don't have a copy of PHP installed anywhere then I should think a batch script would also work:
http://www.brettb.com/ScriptingWindowsFTP.asp
to spceify where you should save the file to on the local pc you use :
get remotefile.sql c:\backup\sitebackup.sql
to get that to run automatically you could set a windows task (or cron). If you had time you could do something in VB that makes the Internet Connection before then executing the batch file.
Sorry I am going off topic, this is starting to become Win32 programming!
