mysql dump with where clause for tables

I need to take a mysqldump of only a certain number of tables from my database.The problem is that i have about 300 tables and i need only dump of about 50 tables that begin with for eg. CUST_

Is there a method by which i can get the dump by using mysqldump and not specifying all the 50 tables exclusively??

Hmm, this is an interesting quesiton.

You may find a stored procedure which could do the job but off the top of my head I’m not sure. I’d suggest checking out and see what they have to say.

Sponsor our Newsletter | Privacy Policy | Terms of Service