Skip to content

Instantly share code, notes, and snippets.

@iammart
Created December 15, 2015 16:07
Show Gist options
  • Select an option

  • Save iammart/0ae8db10e88166341d98 to your computer and use it in GitHub Desktop.

Select an option

Save iammart/0ae8db10e88166341d98 to your computer and use it in GitHub Desktop.
Export table from mysqldump
sed -n -e '/DROP TABLE.*%TABLE%/,/UNLOCK TABLES/p' %DATABASE-DUMP%.sql > %EXPORT%.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment