phpcms 数据表导入

<?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 = [];
$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(str_replace($source_db . '.', '', $create_table_sql));

    // 导入数据
    $insert_data_sql = "INSERT INTO $table SELECT * FROM $source_db.$table";
    $target_conn->query($insert_data_sql);
}

echo "数据表导入完成！";

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