dede服务器转移

<?php
// 原始数据库配置
$source_host = 'old_host';
$source_user = 'old_user';
$source_pass = 'old_pass';
$source_db = 'old_db';

// 目标数据库配置
$target_host = 'new_host';
$target_user = 'new_user';
$target_pass = 'new_pass';
$target_db = 'new_db';

// 连接原始数据库
$source_conn = mysqli_connect($source_host, $source_user, $source_pass, $source_db);
if (!$source_conn) {
    die('无法连接原始数据库: ' . mysqli_connect_error());
}

// 连接目标数据库
$target_conn = mysqli_connect($target_host, $target_user, $target_pass, $target_db);
if (!$target_conn) {
    die('无法连接目标数据库: ' . mysqli_connect_error());
}

// 获取原始数据库中的所有表
$tables = mysqli_query($source_conn, 'SHOW TABLES');
while ($table = mysqli_fetch_array($tables)) {
    $table_name = $table[0];
    
    // 导出表结构
    $create_table_sql = mysqli_query($source_conn, 'SHOW CREATE TABLE ' . $table_name);
    $create_table = mysqli_fetch_array($create_table_sql);
    
    // 创建目标数据库中的表
    mysqli_query($target_conn, $create_table[1]);
    
    // 导出表数据
    $rows = mysqli_query($source_conn, 'SELECT * FROM ' . $table_name);
    while ($row = mysqli_fetch_assoc($rows)) {
        $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 . "'";
        $sql = "INSERT INTO `$table_name`($keys) VALUES($vals)";
        mysqli_query($target_conn, $sql);
    }
}

echo '数据库迁移完成！';

mysqli_close($source_conn);
mysqli_close($target_conn);
?>