PHP数据备份函数_PHP数据库备份与文件压缩实现步骤

function backupDatabase($host, $username, $password, $database, $backupFile) {
    $mysqli = new mysqli($host, $username, $password, $database);
    if ($mysqli->connect_error) {
        die('连接失败: ' . $mysqli->connect_error);
    }
<pre class='brush:php;toolbar:false;'>$tables = [];
$result = $mysqli->query("SHOW TABLES");
while ($row = $result->fetch_row()) {
    $tables[] = $row[0];
}

$sql = "-- PHP数据库备份 --\n";
$sql .= "-- 时间: " . date('Y-m-d H:i:s') . "\n\n";

foreach ($tables as $table) {
    $createResult = $mysqli->query("SHOW CREATE TABLE `$table`");
    $createRow = $createResult->fetch_row();
    $sql .= $createRow[1] . ";\n\n";

    $dataResult = $mysqli->query("SELECT * FROM `$table`");
    while ($dataRow = $dataResult->fetch_assoc()) {
        $columns = array_keys($dataRow);
        $values = array_map(function($value) use ($mysqli) {
            return "'" . $mysqli->real_escape_string($value) . "'";
        }, array_values($dataRow));
        $sql .= "INSERT INTO `$table` (`" . implode('`,`', $columns) . "`) VALUES (" . implode(',', $values) . ");\n";
    }
    $sql .= "\n";
}

file_put_contents($backupFile, $sql);
$mysqli->close();

function compressWithGzip($sourceFile, $destFile) {
    $src = fopen($sourceFile, 'r');
    $gz = gzopen($destFile, 'wb9');
    while (!feof($src)) {
        gzwrite($gz, fread($src, 8192));
    }
    gzclose($gz);
    fclose($src);
}

function compressWithZip($files, $zipFile) {
    $zip = new ZipArchive;
    if ($zip->open($zipFile, ZipArchive::CREATE) === TRUE) {
        foreach ($files as $file) {
            $zip->addFile($file, basename($file));
        }
        $zip->close();
    }
}

# 每天凌晨2点执行备份
0 2 * * * /usr/bin/php /path/to/backup_script.php