Skip to content

qiuyihao/mysqldump

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

A portable tool for mysqldump



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;
}

About

A portable tool for mysqldump

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors

Languages