Skip to content

Instantly share code, notes, and snippets.

@dasegn
Last active October 7, 2016 02:59
Show Gist options
  • Save dasegn/ec175d7884af7afe999b8644a6b357ec to your computer and use it in GitHub Desktop.
Save dasegn/ec175d7884af7afe999b8644a6b357ec to your computer and use it in GitHub Desktop.
#This line get one single table from the full DB dump file in MySQL
sed -n -e '/CREATE TABLE.*`mytable`/,/CREATE TABLE/p' mysql.dump > mytable.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment