dede数据库上传

<?php
require_once(dirname(__FILE__).'/../include/common.inc.php');
require_once(DEDEINC.'/datalistcp.class.php');

// 备份数据库
$bkfile = DEDEDATA.'/backupdata/'.$cfg_dbname.'_'.date('YmdHis').'.sql';
$fp = @fopen($bkfile, 'w');
fwrite($fp, '-- DedeCMS Database Backup'."\n");
fwrite($fp, '-- Generated on '.date('Y-m-d H:i:s')."\n\n");

$dsql = new DedeSql(false);
$dsql->SetQuery("SHOW TABLES");
$dsql->Execute('tb');

while($row = $dsql->GetArray('tb')) {
    $table = $row['Tables_in_'.$cfg_dbname];
    fwrite($fp, 'DROP TABLE IF EXISTS `'.$table.'`;'."\n");
    $dsql->SetQuery("SHOW CREATE TABLE `".$table."`");
    $dsql->Execute('tc');
    while($row2 = $dsql->GetArray('tc')) {
        fwrite($fp, $row2['Create Table'].";\n\n");
    }
    $dsql->SetQuery("SELECT * FROM `".$table."`");
    $dsql->Execute('td');
    $fields = $dsql->GetFields();
    while($row2 = $dsql->GetArray('td')) {
        fwrite($fp, 'INSERT INTO `'.$table.'` VALUES(');
        foreach($fields as $k=>$v) {
            if($k == 0) fwrite($fp, "'".$dsql->EscapeString($row2[$v])."'");
            else fwrite($fp, ","."'".$dsql->EscapeString($row2[$v])."'");
        }
        fwrite($fp, ");\n");
    }
    fwrite($fp, "\n");
}
fclose($fp);

echo "Database backup completed: ".$bkfile;
?>