Skip to content

Instantly share code, notes, and snippets.

@sanasol
Created October 17, 2013 01:22
Show Gist options
  • Select an option

  • Save sanasol/7017840 to your computer and use it in GitHub Desktop.

Select an option

Save sanasol/7017840 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