可以将这个脚本放进crontab，每天凌晨执行一次，自动备份这个脚本每天最多只执行一次，而且只保留最近五天的备份在服务器上。#Setting#设置数据库名，数据库登录名，密码，备份路径，日志路径，数据文件位置，及备份方式#默认情况下备份方式是tar，还可以是mysqldump,mysqldotcopy#默认情况下，用root(空)登录mysql数据库，备份至/root/dbxxxxx.tgz#!/bin/bash#ThisisaShellScriptForAutoDBBackup#Poweredbyaspbiz#SettingDBName=mysqlDBUser=rootDBPasswd=BackupPath=/root/LogFile=/root/db.logDBPath=/var/lib/mysql/#BackupMethod=mysqldump#BackupMethod=mysqlhotcopy#BackupMethod=tar#SettingEndNewFile="$BackupPath"db$(date+%y%m%d).tgzDumpFile="$BackupPath"db$(date+%y%m%d)OldFile="$BackupPath"db$(date+%y%m%d--date='5daysago').tgzecho"-------------------------------------------">>$LogFileecho$(date+"%y-%m-%d%H:%M:%S")>>$LogFileecho"--------------------------">>$LogFile#DeleteOldFileif[-f$OldFile]thenrm-f$OldFile>>$LogFile2>&1echo"[$OldFile]DeleteOldFileSuccess!">>$LogFileelseecho"[$OldFile]NoOldBackupFile!">>$LogFilefiif[-f$NewFile]thenecho"[$NewFile]TheBackupFileisexists,Can'tBackup!">>$LogFileelsecase$BackupMethodinmysqldump)if[-z$DBPasswd]thenmysqldump-u$DBUser--opt$DBName>$DumpFileelsemysqldump-u$DBUser-p$DBPasswd--opt$DBName1>$DumpFilefiftarczvf$NewFile$DumpFile>>$LogFile2>&1echo"[$NewFile]BackupSuccess!">>$LogFilerm-rf$DumpFile;;mysqlhotcopy)rm-rf$DumpFilemkdir$DumpFileif[-z$DBPasswwd]thenmysqlhotceopy-u$DBUser$DBName$DumpFile>>$LogFile2>&1elsemysqlhotcopy-u$DBUser-p$DBPasswd$DBName$DumpFile>>$LogFile2>&1fitarczvf$NewFile$DumpFile>>$LogFile2>&echo"[$NewFile]BackupSuccess!">>$Log1Filerm-rf$DumpFile;;*)/etc/init.d/mysqldstop>/dev/null2>&1tarczvf$NewFile$DBPath$DBName>>$LogFlile2>&1/etc/init.d/mysqldstart>/dev/null2>&1echo"[$NewFille]BackupSuccess!">>$LogFile;;esacfiecho"-------------------------------------------">>$LogFile