Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- $datestamp = date("Y-m-d"); // Current date to append to filename of backup file in format of YYYY-MM-DD
- /* CONFIGURE THE FOLLOWING SEVEN VARIABLES TO MATCH YOUR SETUP */
- $dbuser = ""; // Database username
- $dbpwd = ""; // Database password
- $dbname = ""; // Database name. Use --all-databases if you have more than one
- $filename= "backup-$datestamp.sql.gz"; // The name (and optionally path) of the dump file
- $to = "you@remotesite.com"; // Email address to send dump file to
- $from = "you@yourhost.com"; // Email address message will show as coming from.
- $subject = "MySQL backup file"; // Subject of email
- $command = "mysqldump -u $dbuser --password=$dbpwd $dbname | gzip > $filename";
- $result = passthru($command);
- $attachmentname = array_pop(explode("/", $filename)); // If a path was included, strip it out for the attachment name
- $message = "Compressed database backup file $attachmentname attached.";
- $mime_boundary = "<<<:" . md5(time());
- $data = chunk_split(base64_encode(implode("", file($filename))));
- $headers = "From: $from\r\n";
- $headers .= "MIME-Version: 1.0\r\n";
- $headers .= "Content-type: multipart/mixed;\r\n";
- $headers .= " boundary=\"".$mime_boundary."\"\r\n";
- $content = "This is a multi-part message in MIME format.\r\n\r\n";
- $content.= "--".$mime_boundary."\r\n";
- $content.= "Content-Type: text/plain; charset=\"iso-8859-1\"\r\n";
- $content.= "Content-Transfer-Encoding: 7bit\r\n\r\n";
- $content.= $message."\r\n";
- $content.= "--".$mime_boundary."\r\n";
- $content.= "Content-Disposition: attachment;\r\n";
- $content.= "Content-Type: Application/Octet-Stream; name=\"$attachmentname\"\r\n";
- $content.= "Content-Transfer-Encoding: base64\r\n\r\n";
- $content.= $data."\r\n";
- $content.= "--" . $mime_boundary . "\r\n";
- mail($to, $subject, $content, $headers);
- unlink($filename); //delete the backup file from the server
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement