dedecms数据清空

<?php
// 数据库配置
$db_host = 'localhost';
$db_user = 'your_db_user';
$db_pass = 'your_db_password';
$db_name = 'your_db_name';

// 备份文件名
$backup_file = 'backup_' . date('YmdHis') . '.sql';

// 连接数据库
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);

if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}

// 创建备份文件
$handle = fopen($backup_file, 'w');

// 获取数据库所有表
$tables = $mysqli->query('SHOW TABLES');

while ($table = $tables->fetch_array()) {
    $table_name = $table[0];
    fwrite($handle, 'DROP TABLE IF EXISTS `' . $table_name . '`;' . "\n");
    $create_table = $mysqli->query('SHOW CREATE TABLE `' . $table_name . '`');
    $create_table_sql = $create_table->fetch_row()[1];
    fwrite($handle, $create_table_sql . ";\n\n");

    $rows = $mysqli->query('SELECT * FROM `' . $table_name . '`');
    while ($row = $rows->fetch_assoc()) {
        $keys = array_keys($row);
        $keys = array_map('addslashes', $keys);
        $keys = join('`,`', $keys);
        $keys = "`" . $keys . "`";
        $vals = array_values($row);
        $vals = array_map('addslashes', $vals);
        $vals = join("','", $vals);
        $vals = "'" . $vals . "'";
        fwrite($handle, "INSERT INTO `$table_name`($keys) VALUES ($vals);\n");
    }
    fwrite($handle, "\n");
}

fclose($handle);
$mysqli->close();

echo 'Database backup completed: ' . $backup_file;
?>