備份mysql資料庫
#! /bin/bash
BPATH=/home/backup/mysql_bak
USER="root"
PASSWD="123456"
HOST="192.168.1.5"
DATE=$(date +%Y-%d-%m)
if [ ! -d "$BPATH" ];then
mkdir -p $BPATH
fi
DB=$(mysql -u $USER -h $HOST -p $PASSWD -Bse 'show databases')
for database in $DB
do
if [ ! $database == "information_schema" ;
mysqldump -u $USER -h $HOST -P $PASSWD $database |bzip2> "$BPATH/${DATE}_mysql.gz"
fi
done
導入資料庫
cd $BPATH
tar zxf all_mysql.tar.gz
mysqldump -u $USER -h $HOST -P $PASSWD < mysql.sql
本文轉自super李導51CTO部落格,原文連結: http://blog.51cto.com/superleedo/1889579,如需轉載請自行聯系原作者