PHP code for MySQL backup

[torbjoen]

Hi!

I'd like to make a function on my web-publishing system where my users can backup their database.

I've read about the mysqldump utility of MySQL, but I'd like to peform SQL-queries, and build my backup-file using PHP code.

Now, I guess I could do this myself, but do anybody know where I can find sourcecode for backing up a MySQL database using PHP?

Thanks,
Torbjørn

[bhilimon]

This is the code I use all the time to backup DB's.

<?php
$attrib = date ("F d Y", time());
header("Content-disposition: filename=Complete Backup $attrib.sql");
header("Content-type: application/octetstream");
header("Pragma: no-cache");
header("Expires: 0");
$pResult = mysql_query( "show variables" );
while( 1 ) {
$rowArray = mysql_fetch_row( $pResult );
if( $rowArray == false ) break;
if( $rowArray[0] == "basedir" )
$bindir = $rowArray[1]."bin/";
}
passthru( "mysqldump --user=$SQLUSER --password=$SQLPASS $SQLDB $notable" );
?>

[Anon]

How can you restore this?