PHP实现数据库备份增量备份的方法

$db = new mysqli('localhost', 'username', 'password', 'database_name');

$db = new PDO('mysql:host=localhost;dbname=database_name', 'username', 'password');

$last_backup_time = file_get_contents('/path/to/last_backup_time.txt');

$stmt = $db->prepare("SELECT date FROM backup_logs ORDER BY date DESC LIMIT 1");
$stmt->execute();
$last_backup_time = $stmt->fetchColumn();

$sql = "SELECT * FROM table_name WHERE modify_time > '$last_backup_time'";
$result = $db->query($sql);

$filename = '/path/to/incremental_backup_' . date('YmdHis') . '.csv';
$fp = fopen($filename, 'w');
while ($row = $result->fetch_assoc()) {
    fputcsv($fp, $row);
}
fclose($fp);

$filename = '/path/to/incremental_backup_' . date('YmdHis') . '.sql';
$fp = fopen($filename, 'w');
while ($row = $result->fetch_assoc()) {
    // 使用INSERT语句将数据写入文件
    $insert = "INSERT INTO table_name (column1, column2, ...) VALUES ('" . implode("', '", $row) . "')";
    fwrite($fp, $insert . "
");
}
fclose($fp);

file_put_contents('/path/to/last_backup_time.txt', date('Y-m-d H:i:s'));

$stmt = $db->prepare("INSERT INTO backup_logs (date) VALUES (?)");
$stmt->execute(array(date('Y-m-d H:i:s')));