Skip to content

Instantly share code, notes, and snippets.

@roscius

roscius/Extract Table from Dump

Created May 22, 2014 21:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save roscius/2f5bd3606fd6061e70ae to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save roscius/2f5bd3606fd6061e70ae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Extract Table from Dump
grep -n 'Table structure' dump.sql
19:-- Table structure for table `t1`
40:-- Table structure for table `t2`
61:-- Table structure for table `t3`
sed -n '40,61 p' dump.sql > t2.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment