daoke5/mysqldump

MySQL备份，支持邮件发送

1.0 2017-06-12 02:45 UTC

Requires

• phpmailer/phpmailer: ^5.2

MIT

• qiuyihao

• mysql
• mysqldump

README

use EasyMySQLDump\EasyMySQLDump;
use EasyMySQLDump\EasySendEmail;

/**
 * 1. Mysqldump
 */
$easyMySQLDump = new EasyMySQLDump();
$easyMySQLDump->setDatabase('127.0.0.1', 3306, 'root', '', 'test')
	->setDumpFile('/web/test.mysqldump.sql')
	->mysqldump();

/**
 * 2. Send email
 */
$easySendEmail = new EasySendEmail();
$easySendEmail->debug = true;
$sendResult = $easySendEmail
	->setSubject('mysqldump')
	->setBody('A mail to backup mysqldump file')
	->setSMTP('smtp.yeah.net', 465, '[username]@yeah.net', '[password]')
	->setSender('[sender address]', '[sender name]')
	->setReceiver('[receiver address]')
	->addAttachment($easyMySQLDump->getDumpFile(), 'mysqldump.sql')
	->send();
if ($sendResult === false) {
	echo $easySendEmail->error;
	exit;
}