Skip to content

Instantly share code, notes, and snippets.

@evgalak
Forked from sanasol/gist:7017840
Created February 17, 2014 22:29
Show Gist options
  • Save evgalak/9060509 to your computer and use it in GitHub Desktop.
Save evgalak/9060509 to your computer and use it in GitHub Desktop.
<?php
exec('mysqldump --user=dbuser --password=dbpass --host=127.0.0.1 dbuser > /root/mysql_backups/'.date("d-m-Y").'.sql');
$conn_id = ftp_connect("lepus.ip");
$login_result = ftp_login($conn_id, "storage", "password");
if (ftp_put($conn_id, date("d-m-Y").".sql", "/root/mysql_backups/".date("d-m-Y").".sql", FTP_ASCII))
{
echo "backup uploaded\n";
}
else
{
echo "There was a problem while uploading\n";
}
ftp_close($conn_id);
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment