backup question

[flemingmike]

hi, im looking for a way to make a page that will backup my mysql when i click a button and i can save it locally on any machine i use.  anybody able to help me out with what to search in google?

 

thanks!

[BlueSkyIS]

php backup mysql

[flemingmike]

i found this, i configured it, and it does nothing.  do i have to call a command at all?

 

<?php
include 'config.php';
include 'javascript.php';

$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);


include 'close.php';

?>

[anups]

u can directly use exec function.

 

$filename = bk.sql;
exec("mysqldump -h lhostname -u username --password=dbpassword > $filename");


header("Expires: Mon, 26 Jul 1997 05:00:00 GMT\n");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Content-type: application/zip;\n"); //or yours?
header("Content-Transfer-Encoding: binary");
$len = filesize($filename);
header("Content-Length: $len;\n");
$outname="downfile.zip";
header("Content-Disposition: attachment; filename=\"$outname\";\n\n");

readfile($filename);