This is fast and easy.
I'll post it even though i'm not a TCH client any more because this thread got me to write this script.
Should work great for server to server backups because its FTP.
This can be set up as a one touch backup system or threw a cron job.
><?
// A script produced by BrockHosting.com
// For more help visit http://www.brockhosting.com/bb/viewtopic.php?p=13
$user_name = "not_root"; // YOUR cpanel user name
$user_pass = "password_here"; // YOUR cpanel password
$user_website = "www.brockhosting.com"; // YOUR website do NOT include http://
$ftp_server_ip = "1.2.3.4"; // Server IP here
$ftp_server_user = $user_name."_ftp"; // FTP login name here
$ftp_server_pass = "Hd3Z6wpf"; // FTP password here
$db_list = array("phpbb1","ptp","rcash"); // List of your databases
// Must be "database1","Database2"
// DO NOT ENTER "username_database1", "username_database2"
// Do not edit below this line
$dc = time();
$looper = 0;
while($db_list[$looper] != null) {
$db_name = $db_list[$looper];
$get_this = "http://".$user_name.":".$user_pass."@".$user_website.":2082/getsqlbackup/".$db_name.".gz";
echo "\n<br><br>\nAtempting to downlaod $db_name";
$handle = fopen($get_this, "r");
$save_as = "backup_".$db_name."_".$dc."_.gz";
if ($handle != null) {
$local_handle = fopen($save_as,"x");
echo "\n<br>Saveing \"$db_name\" as \"$save_as\" ";
while(!feof($handle)){ fwrite($local_handle,fgets($handle)); }
}
fclose($handle);
fclose($local_handle);
// Got file need ftp home
$ftp_conn_id = ftp_connect($ftp_server_ip) or die("Couldn't connect to $ftp_server_ip");
ftp_login($ftp_conn_id,$ftp_server_user,$ftp_server_pass);
$upload = ftp_put($ftp_conn_id, $save_as, $save_as, FTP_BINARY);
if ($upload != null) {
echo "\n<br>File Sent!\n";
unlink($save_as);
} else {
echo "\n<br>File NOT SENT!\n";
}
$looper++;
}
?>
