0

It's possible to ignore tables in mysqldump using:

mysqldump -u username -p database --ignore-table=database.table1 > database.sql

Is it possible to ignore certain records in tables while dumping?

rok
  • 9,403
  • 17
  • 70
  • 126
  • Use this link - [Link](https://stackoverflow.com/questions/425158/skip-certain-tables-with-mysqldump) Its already answered their. – Rohit Dalal Jul 18 '17 at 05:35
  • 1
    @RohitDalal no, that is not what the OP asked for. – sitilge Jul 18 '17 at 05:50
  • 1
    Add this check with respective table --where="status='1'" you want to filter the data mysqldump --opt --user=username --password=password table1 table2 --where="table2.status='1'" > test.sql – Rohit Dalal Jul 18 '17 at 05:53
  • @RohitDalal more likely. Make it an answer. – sitilge Jul 18 '17 at 05:59

0 Answers0