Windows 服务器+ Laragon + PHP exec + mysqldump + gzip 备份教学
这是我测试在Windows 服务器里,安装Laragon后,使用PHP exec mysqldump 代码来备份gzip格式。
<?php
$mysqldump = "C:\laragon\bin\mysql\mysql-5.7.33-winx64\bin\mysqlpump.exe";
$gzip = "C:\laragon\bin\git\usr\bin\gzip.exe";
$dbname = "yourdb";
$db_destination = "{$dbname}.sql.gz";
$table = "yourdb_table";
$table_destination = "{$table}.sql.gz";
// 整个database
exce("{$mysqldump} -h localhost -u root {$dbname} | {$gzip} -9 > {$db_destination}");
// 自定database table
exce("{$mysqldump} -h localhost -u root {$dbname} {$table} | {$gzip} -9 > {$table_destination}");
?>
本作品采用《CC 协议》,转载必须注明作者和本文链接