goldenashok: November 2016

Hi Guys it's very easy.

The below code is used to take completely mysql database backup and then send to email

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

Pages