更改mysql数据库名称

-- 创建新数据库
CREATE DATABASE new_database_name;

-- 复制表结构和数据
USE old_database_name;
SET FOREIGN_KEY_CHECKS=0;
SET @tables = NULL;
SELECT GROUP_CONCAT(table_name) INTO @tables
  FROM information_schema.tables
  WHERE table_schema = 'old_database_name';

SET @tables = CONCAT('RENAME TABLE ', @tables, ' TO new_database_name.');
PREPARE stmt FROM @tables;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET FOREIGN_KEY_CHECKS=1;

<?php
$old_db_host = 'localhost';
$old_db_user = 'username';
$old_db_pass = 'password';
$old_db_name = 'old_database_name';

$new_db_host = 'localhost';
$new_db_user = 'username';
$new_db_pass = 'password';
$new_db_name = 'new_database_name';

// 连接到旧数据库
$old_conn = mysqli_connect($old_db_host, $old_db_user, $old_db_pass, $old_db_name);

if (!$old_conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// 创建新数据库
$sql = "CREATE DATABASE $new_db_name";
if (mysqli_query($old_conn, $sql)) {
    echo "New database created successfully";
} else {
    echo "Error creating database: " . mysqli_error($old_conn);
}

// 复制表结构和数据
$sql = "SHOW TABLES";
$result = mysqli_query($old_conn, $sql);

while ($row = mysqli_fetch_array($result)) {
    $table_name = $row[0];
    $sql = "CREATE TABLE $new_db_name.$table_name LIKE $old_db_name.$table_name";
    mysqli_query($old_conn, $sql);

    $sql = "INSERT INTO $new_db_name.$table_name SELECT * FROM $old_db_name.$table_name";
    mysqli_query($old_conn, $sql);
}

mysqli_close($old_conn);
?>