#!/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