mysql定时备份

cd /usr/local/mysql
mkdir backup

cd backup
vim databaseBackup.sh

#!/bin/bash
BACKPATH=/usr/local/mysql/backup
SQL_FILE=ecsr_$(date +%Y%m%d_%H%M%S).sql
LOG_FILE=ecsr_$(date +%Y%m%d_%H%M%S).log
HOST_NAME=ip地址
PORT_NUM=3306
USER_NAME=账号
PASSWORD=密码

if [ ! -d "$BACKPATH" ]; then
    mkdir -p $BACKPATH
fi

/usr/local/mysql/bin/mysqldump -h $HOST_NAME -P $PORT_NUM -u $USER_NAME -p$PASSWORD 
--log-error=$BACKPATH/$LOG_FILE --databases 数据库名 -R -E > $BACKPATH/$SQL_FILE

find $BACKPATH -mtime +7 \( -name "*.sql" -o -name "*.log" \) -exec rm -rf {} \;

0 1 * * * sh /usr/local/mysql/backup/databaseBackup.sh > /dev/null 2>&1

crontab databaseBackup.cron

 注意：这个操作是直接替换该用户下的crontab，而不是新增。