Centos7 mysqldump定时任务,对mysql定时备份数据

mysqldump_bak.sh

#!/bin/bash   
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin   
export PATH      
export LANG=en_US.UTF-8
time="$(date +"%Y%m%d%H%M%S")"


savedir=/cloud/backup/mysql/$time
mkdir -p "$savedir"

cd "$savedir"

/usr/bin/mysqldump -h 127.0.0.1 -uroot -p123456 paas_portal  > paas_portal_"$time".sql
/usr/bin/mysqldump -h 127.0.0.1 -uroot -p123456 paas_permission > paas_permission_"$time".sql
/usr/bin/mysqldump -h 127.0.0.1 -uroot -p123456 paas_bpm > paas_bpm_"$time".sql
/usr/bin/mysqldump -h 127.0.0.1 -uroot -p123456 paas_message_center > paas_message_center_"$time".sql

/etc/crontab

SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root

# 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
  20 3  *  *  * root   sh  /cloud/mysqldump_bak.sh

也可以将多个数据库写成数据 ，如 db = (“paas_portal” “paas_permission” “paas_message_center”)
进行备份，对备份进行压缩 如

/usr/bin/mysqldump -h 127.0.0.1 -uroot -p123456 paas_message_center |gzip > paas_message_center_"$time".sql