<?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”;
}
?>
没有评论:
发表评论