腳本文件內容如下： ``` <?php date_default_timezone_set('PRC'); $config = require __DIR__."/conf.php"; /* * 數據庫備份 */ $backup_path = __DIR__."/backup/"; if (!is_dir($backup_path)){ mkdir(__DIR__."/backup/"); } foreach($config as $k=>$v){ if (!is_dir(__DIR__."/backup/".$v['host']."_".$v['database'])){ mkdir(__DIR__."/backup/".$v['host']."_".$v['database']); } $cmd = "mysqldump -h".$v['host']." -u".$v['user']." -p".$v['pass']." ".$v['database']." > ".__DIR__."/backup/".$v['host']."_".$v['database']."/".date('Ymd',time()).'__'.time().".sql"; exec($cmd,$array,$int); echo $v['host']."_".$v['database']." is backuped!".PHP_EOL; } /* * 刪除歷史備份 */ $databases = scandir($backup_path); foreach($databases as $database){ $database_path = $backup_path.DIRECTORY_SEPARATOR.$database; if ($database === '.' || $database ==='..' || !is_dir($database_path)){ continue; } $versions = scandir($database_path); $files = []; foreach($versions as $key => $version){ $file_path = $database_path.DIRECTORY_SEPARATOR.$version; if ($database === '.' || $database ==='..' || !is_file($file_path)){ continue; } list($name,$time) = explode('__',str_replace('.sql','',$version)); $files[$time] = $file_path; } if (count($files)>2){ ksort($files,SORT_NUMERIC); reset($files); unlink(current($files)); echo current($files)." is deleted!".PHP_EOL; } } ``` 還有一個由二維數組組成的配置文件: ~~~ <?php return [ [ 'host' => '***.***.***.***', 'user' => 'root', 'pass' => 'root', 'database' => 'test' ], [ 'host' => '***.***.***.***', 'user' => 'root', 'pass' => 'root', 'database' => 'test2' ] ]; ~~~