如何使用PHP将MySQL数据库备份到电子邮件[关闭]

Question

I would like to know the code about backup MySQL db to an email like if I click the button "send to my email" it will pop-up a modal (sb-admin bootstrap) saying, input your email. then it will go directly to that email.

Answer 1

In order to do this first of all you will have to dump the database.

You can use the exec() function to execute an external command.

exec('mysqldump --user=... --password=... --host=... DB_NAME > /path/to/output/file.sql');

This will dump the Db. then you will have to attach this file to send mail.

you can use phpmailer to do this

To use PHPMailer:

• Download the PHPMailer script from here: http://github.com/PHPMailer/PHPMailer

• Extract the archive and copy the script's folder to a convenient place in your project.

• Include the main script file -- require_once('path/to/file/class.phpmailer.php');

Now, sending emails with attachments goes from being insanely difficult to incredibly easy:

$email = new PHPMailer();
$email->From      = '[e-mail]';
$email->FromName  = 'Your Name';
$email->Subject   = 'Message Subject';
$email->Body      = $bodytext;
$email->AddAddress( '[e-mail]' );

$file_to_attach = 'PATH_OF_YOUR_FILE_HERE';

$email->AddAttachment( $file_to_attach , 'file.sql' );

return $email->Send();