Guest User

Untitled

a guest
Jan 22nd, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. <?php
  2. $DBUSERNAME = 'YOUR_USERNAME';
  3. $DBPASSWORD = 'YOUR_PASSWORD';
  4. $EMAIL = 'YOUR_EMAIL';
  5.  
  6. $boundary = '==DBBACKUP-'.md5(uniqid(rand(), true));
  7. $date = date('Ymd');
  8. $header = "Content-Type: multipart/mixed; boundary=\"$boundary\"";
  9. $message =
  10. "This is a multi-part message in MIME format.\n".
  11. "--$boundary\n";
  12. mysql_connect('localhost', $DBUSERNAME, $DBPASSWORD);
  13. $result = mysql_query("SHOW DATABASES LIKE '$DBUSERNAME%'");
  14. while ($dbname = mysql_fetch_array($result, MYSQL_NUM)) {
  15. echo "Backup $dbname[0]... ";
  16. $data = chunk_split(base64_encode(shell_exec("mysqldump --opt --complete-insert --default-character-set=utf8 --user=\"$DBUSERNAME\" --password=\"$DBPASSWORD\" $dbname[0] | gzip --best -f")));
  17. $filename = "$dbname[0]-$date.sql.gz";
  18. $message .=
  19. "Content-Transfer-Encoding: base64\n".
  20. "Content-Type: application/octet-stream; name=\"$filename\"\n".
  21. "Content-Disposition: attachment; filename=\"$filename\"\n".
  22. "\n$data\n".
  23. "--$boundary\n";
  24. echo "OK!\n";
  25. }
  26. echo "Mail to $EMAIL... ";
  27. mail($EMAIL, "Database Backup ($date)", $message, $header);
  28. echo "OK!\n";
Add Comment
Please, Sign In to add comment