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 协议》,转载必须注明作者和本文链接
全栈程序员(Blockchain, Web3, Nuxt3+, vue3+, React18+, PHP, MySQL, HTML, CSS, JavaScrIpt/JQuery)
讨论数量: 0
(= ̄ω ̄=)··· 暂无内容!

讨论应以学习和精进为目的。请勿发布不友善或者负能量的内容,与人为善,比聪明更重要!