Skip to content

Instantly share code, notes, and snippets.

@pierophp
Created July 5, 2016 19:08
Show Gist options
  • Save pierophp/23c0dec87971b3850391cea2352fb74f to your computer and use it in GitHub Desktop.
Save pierophp/23c0dec87971b3850391cea2352fb74f to your computer and use it in GitHub Desktop.
Get Table From 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