dbname=dbname
sgrep= searchstring
mysqlshow -ugaofei -p`cat pass_yfb` -h 172.16.3.29 ${dbname} |awk 'NR>4 {print $2}' > ${dbname}_tables_all.cfg
for t_name in `cat ${dbname}_tables_all.cfg ` ; do
mysqldump -ugaofei -p`cat pass_yfb` -h 172.16.3.29 --no-create-info ${dbname} $t_name > tmp_${dbname}_dump.sql
echo $t_name “:”`grep -i ${sgrep} tmp_${dbname}_dump.sql | wc` > ${dbname}_tables_result.out
done;
sgrep= searchstring
mysqlshow -ugaofei -p`cat pass_yfb` -h 172.16.3.29 ${dbname} |awk 'NR>4 {print $2}' > ${dbname}_tables_all.cfg
for t_name in `cat ${dbname}_tables_all.cfg ` ; do
mysqldump -ugaofei -p`cat pass_yfb` -h 172.16.3.29 --no-create-info ${dbname} $t_name > tmp_${dbname}_dump.sql
echo $t_name “:”`grep -i ${sgrep} tmp_${dbname}_dump.sql | wc` > ${dbname}_tables_result.out
done;