使用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 = "[email protected]";

  $mail_recver = "[email protected]";

  $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."

  ?>