// Create the mysql backup file // edit this section $dbhost = "localhost"; // usually localhost $dbuser = "******"; //enter your database username here $dbpass = "******"; //enter your database password here $dbname = "cityhow-pagodap"; // enter your database name here $sendto = "Send To <*****@*****.**>"; $sendfrom = "Send From <*****@*****.**>"; $sendsubject = "Daily Database Backup"; $bodyofemail = "Here is the daily backup of my database."; // don't need to edit below this section $backupfile = $dbname . date("Y-m-d") . '.sql.gz'; system("mysqldump -h {$dbhost} -u {$dbuser} --password={$dbpass} {$dbname} | gzip > {$backupfile}"); // Mail the file include 'Mail.php'; include 'Mail/mime.php'; $message = new Mail_mime(); $text = "{$bodyofemail}"; $message->setTXTBody($text); $message->AddAttachment($backupfile); $body = $message->get(); $extraheaders = array("From" => "{$sendfrom}", "Subject" => "{$sendsubject}"); $headers = $message->headers($extraheaders); $mail = Mail::factory("mail"); $mail->send("{$sendto}", $headers, $body); // Delete the file from your server unlink($backupfile);