crontab
vim /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
# 系统定时任务
00 01 * * * /var/mysql/sh/dbbackup.sh
# For details see man 4 crontabs
# Example of job definition:
# .---------------- minute (0 - 59)
# | .------------- hour (0 - 23)
# | | .---------- day of month (1 - 31)
# | | | .------- month (1 - 12) OR jan,feb,mar,apr ...
# | | | | .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# | | | | |
# * * * * * user-name command to be executed
dbbackup.sh
#!/bin/bash
nowDate=`date +%Y-%m-%d_%H-%M-%S`
dumpCommand="mysqldump -uroot -p密码 -h127.0.0.1 数据库名称"
`${dumpCommand} > /var/mysql/bak/pms_backup_${nowDate}.sql`
