Skip to content

Instantly share code, notes, and snippets.

@duduribeiro

duduribeiro/mysql_dump_filter_tables.sh

Created February 16, 2019 16:17
Show Gist options
  • Save duduribeiro/777e7c33c2951c8c5fc0741900663967 to your computer and use it in GitHub Desktop.
Save duduribeiro/777e7c33c2951c8c5fc0741900663967 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql dump filtering tables
Raw
mysql_dump_filter_tables.sh
mysqldump -umy_user_name -p database_name --tables my_table1 --where="date_created > '2016-01-01' " > mytable1_filtered_dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment