时时商务社区

标题: 使用PHP备份MySQL和网站发送到邮箱实例代码 [打印本页]

作者: 新格网络 时间: 2018-2-14 06:01

         [U]复制代码[/U] 代码如下:
#!/usr/local/bin/php.cli
//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."
?>


您可能感兴趣的文章:

用PHP实现XML备份Mysql数据库

PHP XML备份Mysql数据库

mysql命令行还原phpMyAdmin导出的含有中文的SQL文件

备份mysql数据库的php代码(一个表一个文件)

PHP备份/还原MySQL数据库的代码

详解MYSQL的备份还原(PHP实现)

使用PHP备份MYSQL数据的多种方法

php实现MySQL数据库备份与还原类实例

thinkPHP使用pclzip打包备份mysql数据库的方法

php简单备份与还原MySql的方法

欢迎光临时时商务社区 (http://bbs.4435.cn/)