使用PHP备份MySQL和网站发送到邮箱实例代码

2015-01-24信息快讯网

这篇文章主要介绍了使用PHP备份MySQL和网站发送到邮箱的方法,大家参考使用吧

#!/usr/local/bin/php.cli
<?php
require_once './lib/swift_required.php';

//MySQL $mysql_dbname = "db"; $mysql_user = "user"; $mysql_pass = "pass"; $mysql_file = "./xxx.sql"; $mysql_charset = "utf8"; system("mysqldump --default-character-set=$mysql_charset --opt -u$mysql_user -p$mysql_pass $mysql_dbname > $mysql_file");

//Backup WWW File $www_path = "../www/"; @$final_file = "./xxx_com_".date("Y_m_d").".zip"; system("zip -r -q $final_file $www_path $mysql_file");

//E-Mail @$mail_title = "Backup for Coder4.com ".date("Y_m_d"); $mail_sender = "xxx_send@vip.qq.com"; $mail_recver = "xxx_recv@vip.qq.com"; $mail_body = "See attachments"; $mail_file = $final_file; $sendmail_cmd = "/usr/sbin/sendmail -bs";

//Create E-Mail $message = Swift_Message::newInstance(); $message->setSubject($mail_title); $message->setFrom(array($mail_sender)); $message->setTo(array($mail_recver)); $message->setBody($mail_body); $message->attach(Swift_Attachment::fromPath($mail_file)); //echo $message->toString();

//Send E-Mail $transport = Swift_SendmailTransport::newInstance($sendmail_cmd); $mailer = Swift_Mailer::newInstance($transport); $result = $mailer->send($message);

//Delete unlink($final_file); unlink($mysql_file);

//End echo "All backup success." ?>

©2014-2024 dbsqp.com