mysqlbackup.php:
array( 'localhost', 'root', 'password', array(),//为空备份全部数据库，否则备份这些数据库 'd:/xampp/mysql/bin/mysqldump', //备份工具 dirname(__file__)./localhost,//目录加主机名 5,//删除前5天的sql文件 ),); foreach($configs as $config) { backup($config); } function backup($config) { list($host, $username, $password, $databases, $backuptool, $backupdir, $day) = $config; $command = $backuptool -u $username -h $host -p$password %s > %s; $logsfile = $backupdir.'/'.date('ymd').'.log'; $backfilename = $backupdir.'/'.date('ymd').%s.sql; //备份的sql文件，以数据库命名 if(!is_dir($backupdir)) { mkdir($backupdir, 0755 , true); } //删除前十天的备份文件 get_dir_files($backupdir, $returnval); if($returnval) { foreach($returnval as $v) { $time = filemtime($v); if($time open($zipname, ziparchive::overwrite) === true) { $zip->addfile($outputfile, $filename.'.'.pathinfo($outputfile,pathinfo_extension)); $zip->close(); }else { throw new exception('ziparchive open error!'); } $resource = file_get_contents($zipname); file_put_contents($backupdir.'/'.$zipname, $resource); unlink($zipname); unlink($outputfile); $message = date('y-m-d h:i:s').$database backup complete!/r/n; logs($logsfile, $message); } }catch(exception $e) { $message = date('y-m-d h:i:s').$e->getline().' '.$e->getmessage()./r/n; logs($logsfile, $message); } } } function getdatabases($host, $username, $password) { $databases = array(); try { $mysqli = new mysqli($host, $username, $password); $result = $mysqli->query(show databases); if($result) { while($row = $result->fetch_row()) { (current($row)!='information_schema' && current($row)!='mysql' && current($row)!='performance_schema') && $databases[] = current($row); } $result->free_result(); } $mysqli->close(); }catch(exception $e) { $message = date('y-m-d h:i:s').$e->getline().' '.$e->getmessage()./r/n; logs($logsfile, $message); } return $databases; } function logs($file, $contents) { $dirname = dirname($file); try { if(!is_dir(dirname($file)) || !is_writeable(dirname($file))) { throw new exception(file is not direcotory or file can't write); } file_put_contents($file, $contents, file_append); }catch(exception $e) { $message = date('y-m-d h:i:s').$e->getline.' '.$e->getmessage()./r/n; logs($logfile, $message); } } //获取当前目录下的文件（不包含子文件夹） function get_dir_files($currpath, &$returnval=array()) { if(is_dir($currpath)) { $currpath = (substr($currpath,-1,1)=='/')?substr($currpath,0,strlen($currpath)-1):$currpath; if($handler = opendir($currpath)) { while(($filename = readdir($handler)) !== false) { if($filename != '.' && $filename != '..' && $filename[0] != '.') { if(is_file($currpath . '/' . $filename)) { $returnval[] = $currpath . '/' . $filename; } } } closedir($handler); } } }?>
mysqlbackup.bat：
d:/xampp/php/php.exe -q d:/wamp/www/php_lib/basic/mysqlbackup.phppause;
linux系统shell备份mysql：
#!/bin/sh# sed -i 's/^m//g' /home/taskschd/backup.sh#注意：^m的输入方式是 ctrl + v ，然后ctrl + mdbs=(test)root_dir=/home/backup/for dbname in ${dbs[@]} do#备份数据backup_dir=$root_dir$dbname'_'$(date +%y%m%d).sql/usr/local/mysql/bin/mysqldump --opt -uroot -pabc $dbname > $backup_dir#删除三天前数据delete_file=$dbname'_'$(date -d -5 day +%y%m%d)'.sql'rm $root_dir$delete_file done
另为一篇shell备份mysql脚本:http://www.cnblogs.com/luoyunshu/p/3435378.html