!/bin/bash
echo "input mysqldump file:"
read fsql
echo "input mysqldump tables name: "
read tn
cat $fsql | grep -n "Table structure for table" | grep $tn | awk -F: '{print $1}' > St
St1=`cat St`
cat $fsql | grep -n "ENABLE KEYS" | grep $tn | awk -F: '{print $1}' > Et
Et1=`cat Et`
echo "$Et1+1" | bc > Et2
Et2=`cat Et2`
sed -n "$St1,$Et2"p $fsql > 1111.sql
rm -rf Et* St
