Re: MySQL back up
| From: | Ken | Date: | Wed, 09 Oct 2002 11:24:50 +0000 |
| Subject: | Re: MySQL back up | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-119411@lists.php.net to get a copy of this message | ||
Here is the code I tired to use:
<?php
session_start();
require("./config.php");
$sqlserver = $server1;
$sqlusername = $username1;
$sqlpassword = $password1;
$sqldatabase = $database1;
$nam=date('D,d-m-Y');
@ $db = mysql_pconnect($sqlserver, $sqlusername, $sqlpassword);
if (!$db)
{
echo "Could not connect to MySQL";
exit;
}
$backup=@passthru("mysqldump --opt \"$sqldatabase\" > $backupdir/$nam.sql");
passthru("gzip $backupdir/$nam.sql");
?>