You need to use exec, system, etc. Here is a script that I recently put together. It
backs up the database, and pushes it as a download to the user.
<?php
$filename = "db_backup_" . date("n-j-y");
header("Content-Disposition: filename=$filename.sql");
header("Content-Type: application/force-download");
exec("mysqldump -c -q user -u webserver -ppassword", $sql);
for($i = 0; $i < count($sql); $i++) {
echo $sql[$i] . "\r\n";
}
?>
Hope this helps,
Joseph
"John Taylor-Johnston" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> Anyone do MySQLDump using PHP ?
>
> http://www.mysql.com/doc/en/mysqldump.html
>
> My code is:
> mysqldump -u ****** -p ****** -A > /home/mybackups/dump_all.sql
>
> I would like to pull it off using PHP, remotely.
>
> $date = date ("Ymd");
> $to_path = "/home/MyBackups/$date/dump_all.sql";
>
> mysqldump -u ****** -p ****** -A > $to_path;
>
> mysqldump is not PHP?!
>
> John
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
