« previous next »
Pages: [1]   Go Down

Author Topic: mysql dump with where clause for tables  (Read 1611 times)

oppiniated

  • New Member
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
mysql dump with where clause for tables
« on: December 31, 2008, 04:12:32 AM »
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??
Logged

milesburton

  • Regular Member
  • **
  • Posts: 75
  • Karma: +0/-0
    • View Profile
Re: mysql dump with where clause for tables
« Reply #1 on: February 04, 2009, 10:53:08 AM »
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.
Logged
Pages: [1]   Go Up
« previous next »