php mysql自动定时备份_php 发送mysql数据自动备份的邮件实现方法

为大家讲述一下 PHP给自己发送自动备份的MysqL数据表邮件，感兴趣的小伙伴，下面一起跟随编程之家 jb51.cc的小编来看看吧。

经测试代码如下：

/**

* 自动备份的MysqL数据表邮件发送

*

* @param

* @arrange (512.笔记) jb51.cc

**/

$dbhost = "yourhost"; // usually localhost

$dbuser = "yourusername";

$dbpass = "yourpassword";

$dbname = "yourdb";

$sendto = "Webmaster ";

$sendfrom = "Automated Backup ";

$sendsubject = "Daily MysqL Backup";

$bodyofemail = "Here is the daily backup.";

// don't need to edit below this section

$backupfile = $dbname . date("Y-m-d") . '.sql';

system("MysqLdump -h $dbhost -u $dbuser -p$dbpass $dbname > $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);

/*** 代码来自编程之家 jb51.cc(jb51.cc) ***/

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

如您喜欢交流学习经验，点击链接加入交流1群：1065694478(已满)交流2群：163560250