dz论坛更换域名

// 假设使用的是Discuz! 论坛
// 迁移数据库
$old_db_host = 'old_host';
$old_db_user = 'old_user';
$old_db_pass = 'old_pass';
$old_db_name = 'old_db';

$new_db_host = 'new_host';
$new_db_user = 'new_user';
$new_db_pass = 'new_pass';
$new_db_name = 'new_db';

$old_conn = mysqli_connect($old_db_host, $old_db_user, $old_db_pass, $old_db_name);
$new_conn = mysqli_connect($new_db_host, $new_db_user, $new_db_pass, $new_db_name);

// 迁移数据
$sql = "SELECT * FROM pre_forum_post";
$result = mysqli_query($old_conn, $sql);

while ($row = mysqli_fetch_assoc($result)) {
    $new_sql = "INSERT INTO pre_forum_post (pid, fid, tid, author, subject, dateline, message, useip) 
                VALUES ('$row[pid]', '$row[fid]', '$row[tid]', '$row[author]', '$row[subject]', '$row[dateline]', '$row[message]', '$row[useip]')";
    mysqli_query($new_conn, $new_sql);
}

mysqli_close($old_conn);
mysqli_close($new_conn);

# Apache服务器配置文件.htaccess
RewriteEngine On
RewriteCond %{HTTP_HOST} ^old-domain\.com$ [NC]
RewriteRule ^(.*)$ http://new-domain.com/$1 [R=301,L]