mysql利用mysqldump定时自动备份mysql数据库

@echo off
set file_dir=d:/a
rem 备份文件所在的目录
set file_name=%date:~0,10%-%time:~0,2%-%time:~3,2%-%time:~6,2%
rem 备份文件名
C:/mysql/bin/mysqldump.exe -u root -p123456 databasename> %file_dir%/%file_name%.sql
rem C:/mysql/bin/mysqldump.exe为mysqldump程序所在地址，root为用户名，123456为密码，
databasename为待备份的数据库名

*******************************Code Start*****************************
net stop mysql
xcopy c:/mysql/data/bbs/*.* c:/db_bak/bbs/%date:~0,10%/ /S /I
net start mysql
*******************************Code End *****************************

vim /etc/crontab

# remove all old backup files less than 29 days

10 2 1 * * root find /mnt/database/ -name '*.sql.gz' -type f -mtime -29 -mtime +7 -exec rm -f {} ;

# automatically backup mysql every day

15 2 * * * root mysqldump -u root -pPASSWORD --all-databases | gzip > /mnt/database/`date +'/%Y-/%m-/%d'`.sql.gz

cron中任务计划的格式为：

# m h dom mon dow user  command