#!/bin/bash
DUMP=mysqldump
HOST=IP
OUT_DIR=/mnt/data/dir/
DB_NAME1=DB_NAME1
DB_NAME2=DB_NAME2
DB_NAME3=DB_NAME3
DB_USER=root
DB_PASS=root
DATE=`date +%Y%m%d%H%M`
OUT_SQL1=$DATE'DB_NAME1'.sql
OUT_SQL2=$DATE'DB_NAME2'.sql
OUT_SQL3=$DATE'DB_NAME3'.sql
$DUMP -h $HOST -u$DB_USER -p$DB_PASS $DB_NAME1 > $OUT_DIR/$OUT_SQL1
$DUMP -h $HOST -u$DB_USER -p$DB_PASS $DB_NAME2 > $OUT_DIR/$OUT_SQL2
$DUMP -h $HOST -u$DB_USER -p$DB_PASS $DB_NAME3 > $OUT_DIR/$OUT_SQL3
#mysqldump -h IP -uroot -proot DB_NAME1> /mnt/dir/DB_NAME1.sql
linux下mysql自动备份脚本,做个记录