mysql back up databases

<?php
//mysql back up databases
set_time_limit(0);
$date = date(“mdy-hia”);
$dbserver = “localhost”;
$dbuser = “混世魔王”;
$dbpass = “混世魔王”;
$dbname = “混世魔王”;
$file = “$dbname.sql.gz”;
$gzip = TRUE;
$silent = TRUE;
function write($contents) {
    if ($GLOBALS[‘gzip’]) {
        gzwrite($GLOBALS[‘fp’], $contents);
    } else {
        fwrite($GLOBALS[‘fp’], $contents);
    }
}
mysql_connect ($dbserver, $dbuser, $dbpass);
mysql_select_db($dbname);
//$qy=”SET NAMES BIG5″;
//$result=mysql_db_query($dbname, $qy);
if ($gzip) {
    $fp = gzopen($file, “w”);
} else {
    $fp = fopen($file, “w”);
}
$tables = mysql_query (“SHOW TABLES”);
while ($i = mysql_fetch_array($tables)) {
    $i = $i[‘Tables_in_’.$dbname];
    if (!$silent) {
        echo “Backing up table “.$i.”n”;
    }
    $create = mysql_fetch_array(mysql_query (“SHOW CREATE TABLE “.$i));
    write($create[‘Create Table’].”;nn”);
    $sql = mysql_query (“SELECT * FROM “.$i);
    if (mysql_num_rows($sql)) {
        while ($row = mysql_fetch_row($sql)) {
            foreach ($row as $j => $k) {
                $row[$j] = “‘”.mysql_escape_string($k).”‘”;
            }
            write(“INSERT INTO $i VALUES(“.implode(“,”, $row).”);n”);
        }
    }
}
$gzip ? gzclose($fp) : fclose ($fp);

$use_gzip = “yes”;         
$remove_sql_file = “no”; 
$remove_gzip_file = “no”;

$savepath = “/home/qq/gfx/”;
$senddate = date(“j F Y”);

$date = date(“mdy-hia”);
$filename = “$savepath/$dbname-$date.sql”;
if($use_gzip==”yes”){
$filename2 = $file;
} else {
$filename2 = “$savepath/$dbname-$date.sql”;
}
?>

没有评论:

发表评论

Follow Us

FOLLOW US

Blog Archive

Comments

Blogger 提供支持.

Search This Blog

Tags

header ads