Skip to content

Instantly share code, notes, and snippets.

@lichti
Created July 5, 2016 19:00
Show Gist options
  • Save lichti/428abbba42002a2aaa993f42ea6bb2eb to your computer and use it in GitHub Desktop.
Save lichti/428abbba42002a2aaa993f42ea6bb2eb to your computer and use it in GitHub Desktop.
get a table from a full backup
zcat my-full-backup.sql.gz | sed -n '/^-- Table structure for table `mytable`/,/^-- Table structure for table /p' > my-table.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment