mysqldump with WHERE clause code example
Example: mysqldump with WHERE clause
$> mysqldump -umy_user_name -p database_name --tables my_table1 --where="date_created > '2016-01-01' " > mytable1_filtered_dump.sql
$> mysqldump -umy_user_name -p database_name --tables my_table1 --where="date_created > '2016-01-01' " > mytable1_filtered_dump.sql