Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- echo " = = = = = back up start @ `date` = = = = = "
- BACKUP_DIR="/opt/data/backup"
- DUMP_CMD="/usr/bin/mysqldump"
- HOST="127.0.0.1"
- PORT="3306"
- USER="root"
- PASSWORD="123456"
- cd $BACKUP_DIR
- TIMESTAMP=`date +%F-%H%M`
- DB_TOBACK="test" # 空格分隔多个数据库
- for db in $DB_TOBACK;do
- echo "$db is in process... @ `date`"
- backup_name="$db-$TIMESTAMP.sql"
- $DUMP_CMD -h $HOST -P $PORT -u$USER -p$PASSWORD $db > $backup_name
- gzip $backup_name
- echo "done"
- done
- find $BACKUP_DIR -type f -mtime +10 -name "*.gz" | xargs -r rm -r
- echo " = = = = = back up end @ `date` = = = = = "
Add Comment
Please, Sign In to add comment