Backup and Mail MySQL Database using PHP

[melbin]

This script will show you how to take complete mysql backup using php and email the backup file as attachment.

< ?php
$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
?>

Add this php script in your cronjobs and it will backup the db in some fixed intervals

[Appeplile]

Here's my preferred way: Select the text and click on the Font Family name in the pop-up menu in the Options Bar (it will become highlighted).

[sarulee]

thank you for data

[crownd]

Hi, thanks a lot for your great post, it has really lot of worth for me.

I was looking for a backup solution but they are expensive. I found ESXi which could be interesting.....


Greets! :D

[reddy2011]

very helpful post for me...thanks a lot!

[MiguGrealiek]

However, not all opiate receptors have the same analgesic potency when stimulated does propecia work

[MiguGrealiek]

buy zithromax without prescription online Differences in estrogen pathway may predict sensitivity or resistance to tamoxifen and its antiestrogenic metabolites in tumor cell and its inhibition by tamoxifen metabolites tumor biology factors

[MiguGrealiek]

7 Obesity may elevate risk by 50 in post menopausal women by altering endogenous estrogen production ivermectin pour on

[MiguGrealiek]

ivermectin for cats Eye Doctors Give Breast Cancer Patients One Less Thing to Worry About