php 导出mysql数据库

<?php
// 数据库连接配置
$host = 'localhost';
$user = 'username';
$password = 'password';
$dbname = 'database_name';

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

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

// 设置字符集
$conn->set_charset("utf8");

// 导出文件名
$filename = 'backup_' . date('Y-m-d_H-i-s') . '.sql';

// 打开文件
$handle = fopen($filename, 'w');

// 获取所有表名
$tables = $conn->query('SHOW TABLES');
while ($table = $tables->fetch_array()) {
    $table_name = $table[0];
    
    // 写入表结构
    $result = $conn->query("SHOW CREATE TABLE $table_name");
    $row = $result->fetch_array();
    fwrite($handle, "-- Table structure for table `$table_name`\n");
    fwrite($handle, $row['Create Table'] . ";\n\n");
    
    // 写入表数据
    $result = $conn->query("SELECT * FROM $table_name");
    $fields = $result->fetch_fields();
    while ($row = $result->fetch_assoc()) {
        $values = [];
        foreach ($fields as $field) {
            $values[] = "'" . addslashes($row[$field->name]) . "'";
        }
        $values_str = implode(', ', $values);
        fwrite($handle, "INSERT INTO `$table_name` VALUES ($values_str);\n");
    }
    fwrite($handle, "\n");
}

// 关闭文件
fclose($handle);

echo "数据库导出成功，文件名: " . $filename;

// 关闭数据库连接
$conn->close();
?>