Skip to content

Instantly share code, notes, and snippets.

@optroodt
Created January 7, 2014 11:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save optroodt/8298148 to your computer and use it in GitHub Desktop.
Save optroodt/8298148 to your computer and use it in GitHub Desktop.
Extract single table from mysql dump file.
sed -n -e '/CREATE TABLE.*tablename/,/CREATE TABLE/p' database.sql > table.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment