Parse single table from mysqldump
by sudo on Oct.08, 2009, under Linux
If you wish to pull a single table from a large mysqldump, the following commands will accomplish this.
# grep -n "CREATE TABLE" databasedump.sql
If the table you want starts on line 100, and the proceeding table is on line 150, run the following commands to parse the dump.
# head -n 142 databasedump.sql > parsed.sql
# tail -n 100 parsed.sql > table.sql
Do not use the exact line number returned from grep as you will have the create table statement from the next table.
