0

I wanted to know if it was possible can do a db dump of all the tables in a database, but leaving a couple of tables specified on the command line. this is for mysql. i know there is one for adding specific tables on an sql, but i dont know if you can exclude specific tables. Thanks in advance.

rbz
  • 759
  • 1
  • 8
  • 17
  • 3
    possible duplicate http://stackoverflow.com/questions/425158/skip-certain-tables-with-mysqldump I'm pretty sure this has the answer that you want. – Wes Nov 22 '10 at 23:15

1 Answers1

2

Mysqldump has an --ignore-table option.

JOTN
  • 6,120
  • 2
  • 26
  • 31
  • awesome, i was looking in the man page and it didnt have it, but it did on --help page. i do have a question, how is this set up on the --help page its --ignore-table=database.table, what if i want multiple tables? – rbz Nov 23 '10 at 00:12
  • nm, the above link answered it thanx – rbz Nov 23 '10 at 00:13