Can mysql restore a single table from a large mysqldump?
I have found two solutions, one using 

grep -n "Table Structure" mydump.sql
# identify the first and last line numbers (n1 and n2) of desired table
sed -n n1,n2p mydump.sql &gt; mytable.sql # (e.g. sed -n 48,112p)


and one using awk

awk '/Table Structure for table .table1./, /Table structure for table .cultivars./{print}' mydump.sql &gt; mytable.sql