#!/bash/bin
name=""
index=1
for param in $@
do
if [ $index -eq 1 ]
then
let index++
continue
fi
mysqldump -h localhost(IP) -uroot -p密码 $1 $param > $param'.sql'
sqlName=$param'.sql'
name=${name}' '$sqlName
done
fileName=$1'.tar.gz'
tar -czf $fileName $name
let index=1
for p in $@
do
if [ $index -eq 1 ]
then
let index++
continue
fi
fileName=$p'.sql'
rm -rf $fileName
done
mysql批量导表shell脚本
最新推荐文章于 2022-08-11 17:50:27 发布