Skip to content

Instantly share code, notes, and snippets.

@sergeycherepanov

sergeycherepanov/mysqldump by mask

Created December 8, 2015 23:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sergeycherepanov/6c2c9cd803ece897b8ee to your computer and use it in GitHub Desktop.
Save sergeycherepanov/6c2c9cd803ece897b8ee to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysqldump by mask
mysqldump --no-create-info --single-transaction --skip-triggers -uroot -p pradam $(mysql -uroot -proot pradam -e "show tables" | grep ^sales | tr '\n' ' ') > sales_tables.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment