~$ sudo apt-get

Parse single table from mysqldump

by 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.

Leave a Reply

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit our friends!

A few highly recommended friends...