Mysqldump via php?

[roboteddy]

Hello,

I'm helping code an open source php/mysql forums software.. http://www.yabb.info/community/ if you are interested.

Anyways, as a feature, I wanted to let people back up their mysql databases. Because the forums will likely be running with safe mode on (most people use free hosts for hosting bb's), I can't exec a mysqldump command. I want to know if there is a script for dumping a mysql database in a format that would allow it to be queried back in. I've looked around and can't find a script that does that, besides phpmyadmin. Any ideas?

[Anon]

why not go through the phpmyadmin code and pull from there?

grep dump *

I found some code in there that might help you. Check out tbl_dump.php.

[[deleted]]

You can do a 'select into outfile', read the MySQL manual.