织梦数据库转移

<?php
// 源数据库配置
$source_host = 'source_host';
$source_user = 'source_user';
$source_pass = 'source_pass';
$source_db = 'source_db';

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

// 连接源数据库
$source_conn = new mysqli($source_host, $source_user, $source_pass, $source_db);
if ($source_conn->connect_error) {
    die("源数据库连接失败: " . $source_conn->connect_error);
}

// 连接目标数据库
$target_conn = new mysqli($target_host, $target_user, $target_pass, $target_db);
if ($target_conn->connect_error) {
    die("目标数据库连接失败: " . $target_conn->connect_error);
}

// 获取源数据库中的所有表
$tables = array();
$result = $source_conn->query("SHOW TABLES");
while ($row = $result->fetch_array()) {
    $tables[] = $row[0];
}

// 逐个表进行数据转移
foreach ($tables as $table) {
    // 导出表结构
    $create_table_sql = $source_conn->query("SHOW CREATE TABLE `$table`")->fetch_row()[1];
    $target_conn->query($create_table_sql);

    // 导出表数据
    $rows = $source_conn->query("SELECT * FROM `$table`");
    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 . "'";
        $sql = "INSERT INTO `$table`($keys) VALUES ($vals)";
        $target_conn->query($sql);
    }
}

echo "数据库转移完成！";

// 关闭连接
$source_conn->close();
$target_conn->close();
?>