//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."
?>
如对本文有疑问, 点击进行留言回复!!
DM数据库:dm.ini参数(五)预先装载表、客户端缓存、REDO 日志、事务相关参数
php+mysql获取7天、30天的统计数据,没有数值的补充0 By勤勤学长
第一章 第六小节Duilib的WindowImplBase基类OnCreate函数中调用AttachDialog函数
网友评论