我正在使用以下脚本来转储数据库。它很棒。我想添加一些功能,它首先检查数据库表是否已经转储,如果转储存在,则应将其跳过并移至下一个表。
DB_host=127.0.0.1
DB_user=root
DB=mydb
DB_pass=mydbpassword
DIR=/
[ -n "$DIR" ] || DIR=.
test -d $DIR || mkdir -p $DIR
echo "Dumping tables into separate SQL command files for database '$DB' into dir=$DIR"
tbl_count=0
for t in $(mysql -NBA -h $DB_host -u $DB_user -p$DB_pass -D $DB -e 'show tables')
do
echo "DUMPING TABLE: $t"
mysqldump -h $DB_host -u $DB_user -p$DB_pass $DB $t > $DIR/$t.sql
(( tbl_count++ ))
done
echo "$tbl_count tables dumped from database '$DB' into dir=$DIR"
更改此代码块:
echo "DUMPING TABLE: $t"
mysqldump -h $DB_host -u $DB_user -p$DB_pass $DB $t > $DIR/$t.sql
(( tbl_count++ ))
对此:
echo "DUMPING TABLE: $t"
if [ -e "$DIR/$t.sql" ]; then
echo "TABLE $DIR/$t.sql exists, skipping..."
else
mysqldump -h $DB_host -u $DB_user -p$DB_pass $DB $t > $DIR/$t.sql
fi
(( tbl_count++ ))
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句