mysql dump with where clause for tables

[oppiniated]

Hi;
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??

[milesburton]

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 mysql.org and see what they have to say.