Can mysql restore a single table from a large mysqldump?

Question

What is the best way to restore a single table from a large (~5GB) database mysqldump file?

---

update: I have found solutions (posted below) using command line tools to parse the table, but is there a way to do this with mysqlimport?

Answer 1

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 -e 'n1,n2, p' mydump.sql > mytable.sql

and one using awk

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

Answer 2

This approach does not get around the issue of having to import a large mysqldumpfile, but from within Mysql you can do the following:

1. restore entire dump

    mysql fakedb < mydump.sql
   

2. delete contents of current table

    mysql
    delete from production.target_table;
   

3. insert from backup table

   insert into production.target_table select * from fakedb.targettable;