<?

// --------------------------------------- //
// Website Database and File System Backup //
// -----   AlfredFox.com           ------- //
// --------------------------------------- //


// Remove No Longer Needed files.zip & SQL Dump (previous backup)
$delFiles = "rm backup/*";
system($delFiles);

// Setup Database connection information
$username="dbUsername";
$password="dbPassword";
$database="dbName";
mysql_connect(localhost,$username,$password);

// Connect to Database
@mysql_select_db($database) or die("Unable to select database");

// Setup Database Dump
$backupFile = 'backup/'.$database . date("Y-m-d-H-i-s") . '.sql';
$mysqlDump = "mysqldump --opt -h localhost -u $username -p$password $database > $backupFile";
system($mysqlDump);

// Close Database Connection
mysql_close();

// Create ZIP File of Filesystem
$zipFiles = "zip -r backup/files.zip ../";
system($zipFiles);

// Create Master Zip File Including DB Dump
$zipMaster = "zip -r backup/".date("Y-m-d")."_backup.zip backup/*";
system($zipMaster);

// FTP File to Backup Server
$ftpUser = "ftpUsername";
$ftpPass = "ftpPassword";
$ftpServer = "ftpHost";
$file1 = "backup/".date("Y-m-d")."_backup.zip";
$file2 = "/public_html/backups/domain.com/".date("Y-m-d")."_backup.zip";
$conn_id = ftp_connect($ftpServer);
$login_result = ftp_login($conn_id, $ftpUser, $ftpPass);
if (ftp_put($conn_id, $file2, $file1, FTP_ASCII)) {
    echo "successfully uploaded $file\n";
} else {
    echo "There was a problem while uploading $file\n";
}
ftp_close($conn_id);

?>