PHP mysql备份与恢复

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

// 连接数据库
$conn = mysqli_connect($host, $user, $pass, $dbname);

if (!$conn) {
    die('连接失败: ' . mysqli_connect_error());
}

// 导出数据库
$backup_file = 'backup_' . date('YmdHis') . '.sql';
$command = "mysqldump --user={$user} --password={$pass} --host={$host} {$dbname} > {$backup_file}";

if (system($command)) {
    echo "备份成功: {$backup_file}";
} else {
    echo "备份失败";
}

mysqli_close($conn);
?>

<?php
$host = 'localhost';
$user = 'username';
$pass = 'password';
$dbname = 'database_name';
$backup_file = 'backup_20230101123456.sql';

// 连接数据库
$conn = mysqli_connect($host, $user, $pass, $dbname);

if (!$conn) {
    die('连接失败: ' . mysqli_connect_error());
}

// 恢复数据库
$command = "mysql --user={$user} --password={$pass} --host={$host} {$dbname} < {$backup_file}";

if (system($command)) {
    echo "恢复成功";
} else {
    echo "恢复失败";
}

mysqli_close($conn);
?>