#!/bin/bash
# Enviroment
PATH=/usr/local/sbin:/usr/bin:/bin
# Configure The Directory of Backup
ROOT=root
ROOTPASS=123456
MYSQLDIR=/backup/mysql
DATETIME=`date -d now +%Y-%m-%d_%H-%M`
# Create Directory
if [ ! -d $MYSQLDIR ]; then
mkdir -p $MYSQLDIR
fi
# ----- Backup MySQL -----
cd /var/lib/mysql/
mysqldump -u$ROOT -p$ROOTPASS -h127.0.0.1 dbtest > $MYSQLDIR/$DATETIME.dbtest.bak.sql
其中 cd /var/lib/mysql/ 目录根据部署情况写:
cat /etc/my.cnf 查看数据目录
mysqldump -u$ROOT -p$ROOTPASS -h127.0.0.1 dbtest [这里可以设置table名] > $MYSQLDIR/$DATETIME.dbtest.bak.sql
定时执行:
30 0 * * * sh /home/mysql_back.sh
service crond start