php数据库备份程序

// 检查数据库连接配置
$host = 'your_database_host';
$port = 'your_database_port';
$user = 'your_database_user';
$password = 'your_database_password';
$dbname = 'your_database_name';

$conn = new mysqli($host, $user, $password, $dbname, $port);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 确保备份文件路径存在且可写
$backup_file_path = 'path/to/backup/file.sql';
if (!file_exists(dirname($backup_file_path))) {
    mkdir(dirname($backup_file_path), 0755, true);
}

$fp = fopen($backup_file_path, 'w');
if (!$fp) {
    die("无法创建备份文件: " . $backup_file_path);
}

// 设置正确的字符集
mysqli_set_charset($conn, 'utf8mb4');

// 在备份SQL文件中添加字符集声明
$backup_sql = "-- 默认字符集为utf8mb4\n";
$backup_sql .= "SET NAMES utf8mb4;\n";

<?php
$host = 'your_database_host';
$port = 'your_database_port';
$user = 'your_database_user';
$password = 'your_database_password';
$dbname = 'your_database_name';
$backup_file_path = 'path/to/backup/file.sql';

$conn = new mysqli($host, $user, $password, $dbname, $port);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

mysqli_set_charset($conn, 'utf8mb4');

$backup_sql = "-- 默认字符集为utf8mb4\n";
$backup_sql .= "SET NAMES utf8mb4;\n";

$result = $conn->query("SHOW TABLES");
while ($table = $result->fetch_array()) {
    $table_name = $table[0];
    $backup_sql .= "-- 备份表: $table_name\n";
    $backup_sql .= "DROP TABLE IF EXISTS `$table_name`;\n";
    $create_table_sql = $conn->query("SHOW CREATE TABLE `$table_name`")->fetch_row()[1];
    $backup_sql .= "$create_table_sql;\n";
    $rows = $conn->query("SELECT * FROM `$table_name`");
    while ($row = $rows->fetch_assoc()) {
        $backup_sql .= "INSERT INTO `$table_name` VALUES (";
        $values = array();
        foreach ($row as $value) {
            $values[] = "'" . mysqli_real_escape_string($conn, $value) . "'";
        }
        $backup_sql .= implode(', ', $values) . ");\n";
    }
    $backup_sql .= "\n";
}

if (!file_exists(dirname($backup_file_path))) {
    mkdir(dirname($backup_file_path), 0755, true);
}

$fp = fopen($backup_file_path, 'w');
if (!$fp) {
    die("无法创建备份文件: " . $backup_file_path);
}

fwrite($fp, $backup_sql);
fclose($fp);

$conn->close();

echo "数据库备份完成，备份文件保存路径: " . $backup_file_path;
?>