如何使用PHP實作一個簡單的資料備份功能

<?php
$sourceFile = 'data.txt'; // 需要备份的源文件
$backupFile = 'backup/data.txt'; // 备份的目标文件

// 打开源文件和备份文件
$source = fopen($sourceFile, 'r');
$backup = fopen($backupFile, 'w');

// 复制源文件到备份文件
while (!feof($source)) {
    $content = fread($source, 8192);
    fwrite($backup, $content);
}

// 关闭文件
fclose($source);
fclose($backup);

echo "文件备份完成！";
?>

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$backupFile = 'backup/database.sql'; // 备份的目标文件

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

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

// 设置编码
$conn->set_charset("utf8");

// 备份数据库结构和数据
$command = "mysqldump -u ".$username." -p".$password." ".$dbname." > ".$backupFile;
exec($command);

$conn->close();

echo "数据库备份完成！";
?>