php数据库备份与恢复

<?php
$host = 'localhost';
$user = 'username';
$pass = 'password';
$dbname = 'database_name';

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

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

// 创建备份文件
$backup_file = 'backup_' . date('Y-m-d_H-i-s') . '.sql';
$command = "mysqldump -h $host -u $user -p$pass $dbname > $backup_file";
exec($command);

echo "数据库备份成功，备份文件: $backup_file";

$conn->close();
?>

<?php
$host = 'localhost';
$user = 'username';
$pass = 'password';
$dbname = 'database_name';
$backup_file = 'backup_2023-04-01_12-34-56.sql';

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

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

// 恢复数据库
$command = "mysql -h $host -u $user -p$pass $dbname < $backup_file";
exec($command);

echo "数据库恢复成功";

$conn->close();
?>