#!/bin/bash
#export MySql table and table's data
#table's name in single file,shell to read this file and read by line
#shell script by okhelper ,2016-02-26
cat $1 | while read LINE
do
CMD="mysqldump -h 127.0.0.1 -uroot -proot fsdb $LINE"
echo $CMD
#sleep 1
eval $CMD |tee $LINE.sql
#sleep 1
done
echo ""
echo "backup fsdb's table complet!"
#export MySql table and table's data
#table's name in single file,shell to read this file and read by line
#shell script by okhelper ,2016-02-26
cat $1 | while read LINE
do
CMD="mysqldump -h 127.0.0.1 -uroot -proot fsdb $LINE"
echo $CMD
#sleep 1
eval $CMD |tee $LINE.sql
#sleep 1
done
echo ""
echo "backup fsdb's table complet!"