aspcms数据库转移

<?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 = mysqli_connect($source_host, $source_user, $source_pass, $source_db);

// 连接目标数据库
$target_conn = mysqli_connect($target_host, $target_user, $target_pass, $target_db);

// 检查连接是否成功
if (!$source_conn || !$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);
    
    // 导出表数据
    $rows = mysqli_query($source_conn, 'SELECT * FROM ' . $table_name);
    $data = mysqli_fetch_all($rows, MYSQLI_ASSOC);
    
    // 在目标数据库中创建表
    mysqli_query($target_conn, $create_table[1]);
    
    // 插入数据
    foreach ($data as $row) {
        $keys = array_keys($row);
        $values = array_values($row);
        $query = 'INSERT INTO ' . $table_name . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', array_map('mysqli_real_escape_string', $values)) . ')';
        mysqli_query($target_conn, $query);
    }
}

echo '数据库迁移完成';

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