1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

<?php
//mysql back up databases
set_time_limit(0);
$date = date("mdy-hia");
$dbserver = "localhost";
$dbuser = "root";
$dbpass = "xunuo";
$dbname = "www.swhack.cn";
$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";
}
?>