sql语句导出mysql数据库

mysqldump -u username -p database_name > backup.sql

<?php
$host = 'localhost';
$username = 'your_username';
$password = 'your_password';
$database_name = 'your_database_name';

// 创建连接
$conn = new mysqli($host, $username, $password, $database_name);

// 检查连接
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// 导出数据库
$export = 'mysqldump --user=' . $username . ' --password=' . $password . ' --host=' . $host . ' ' . $database_name . ' > backup.sql';

exec($export);

echo "Database exported successfully.";

$conn->close();
?>

GRANT SELECT, SHOW VIEW, TRIGGER ON your_database_name.* TO 'your_username'@'localhost';
FLUSH PRIVILEGES;

[mysqld]
wait_timeout = 3600
interactive_timeout = 3600

-- 检查数据库字符集
SHOW CREATE DATABASE your_database_name;

-- 修改数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 检查表字符集
SHOW CREATE TABLE your_table_name;

-- 修改表字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;