How to dump multiple tables with a where condition into single file

Question

I have 6 tables named as table1, table2, table3, table4, table5, table6 and each table contain a field status . Before taking the backup i want to check status='N' in each tables. I have the following code

mysqldump -t -u root -p dbname table1 -w"Status = 'N'" >/backup/test.sql;

this code help only for one table and create 6 file. How can i get the single dump file contain the details of this 6 tables

Not exactly actually tables like tableA, tableB, tableC, tableD, tableE, tableF. this is the correct scenario — Rince Dominic
– Rince Dominic, Commented Jun 26, 2014 at 11:03

Arjun Pokkattu · Accepted Answer · 2014-06-26 11:36:35Z

1

Just try mysqldump -t -u root -p dbname table1 table2 table3 table4 table5 table6 -w"Status = 'N'" >/backup/test.sql;

I think it will meet your requirement..

answered Jun 26, 2014 at 11:36

Arjun Pokkattu

1374 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to dump multiple tables with a where condition into single file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related