Mysql Dump

[Anon]

I want to dump a database after certain conditions are met with an if statement inside a php file and have the dump sent to me via email.

Problem is that I cannot find out how to do it.

I tried the following that just produced a blank page:

<?php
header('Content-type: application/octet-stream');
echo mysqldump -umyusername -pmypassword mydbname;
?>

[Anon]

oh, and by the way, I want to do an "optimize" command afterwards and again I don't know how...

[[deleted]]

Well, you're not really doing anything with email here yet.

use the backticks or system or exec or whatever to call mysqpdump and have mysqldump output the dump to a file (mysqldump database >filename.dump)
Then use one of the wonderfull Mime email classes poasted right here on the site (articles and tips sections) to send the file as an attachment to an email.

[[deleted]]

Optimize is explained in the MySQL manual.
Use exec or system to run it.
Note: optimize can take a long time, be carefull about the max_execution_time of PHP.

[Anon]

Isnt it possible to dump the data into a variable and then send it with mail()?
I think that woulb be much easier because I would not have to care about the created file. (and delete it afterwards)

[[deleted]]

That will probably work for small databases, but I would not recommend it.
For example, what if you have a 500MB database?