MySQL导入

 

#!/bin/sh

DATADIR=/var/ftp/datasql

#MySQL Info
database1=db1
database2=db2
user1=root
psw1=12344321
user2=root
psw2=12344321

cd $DATADIR

rm -rf daily$database1$(date -d  "-1 day" +%y%m%d).tar.gz
rm -rf daily$database2$(date -d  "-1 day" +%y%m%d).tar.gz

#decompressing files
for file in $(ls daily*)
do
echo $file
tar xvzf $file
done

echo "start import sql..."
for file in $(ls $database1*)
do
echo $file
#mysql -u$user1 -p$psw1 $database1 < $file
done

for file in $(ls $database2*)
do
echo $file
#mysql -u$user2 -p$psw2 $database2 < $file
done

rm -rf *.sql

echo "end"

 

 

    导入sql文件shell