Re: mysqldump all tables except 2 in a database

2004-09-01 Thread SGreen
t; - Original Message - > From: "Emi Lu" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 31, 2004 4:13 PM > Subject: mysqldump all tables except 2 in a database > > > > Hello all, > > > > In mysql, do we have a

Re: mysqldump all tables except 2 in a database

2004-08-31 Thread Jeff Barr
I have a script on my site that I call "smalltables". When run, it echoes out the names of all of the tables _except_ for the large ones that I don't back up. I then use this in the mysqldump command line: /usr/local/mysql/bin/mysqldump -q --user=UUU --host=localhost --password=PPP DB_NAME `small

Re: mysqldump all tables except 2 in a database

2004-08-31 Thread Rhino
- Original Message - From: "Emi Lu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 31, 2004 4:13 PM Subject: mysqldump all tables except 2 in a database > Hello all, > > In mysql, do we have a way to "mysqldump" all tables e

Re: mysqldump all tables except 2 in a database

2004-08-31 Thread Paul DuBois
At 16:13 -0400 8/31/04, Emi Lu wrote: Hello all, In mysql, do we have a way to "mysqldump" all tables except two in a database. I know we have the way only dump schema, only data, a specific table, both data structure and data. But could someone help me about dumping all tables in a structure ex

mysqldump all tables except 2 in a database

2004-08-31 Thread Emi Lu
Hello all, In mysql, do we have a way to "mysqldump" all tables except two in a database. I know we have the way only dump schema, only data, a specific table, both data structure and data. But could someone help me about dumping all tables in a structure except two. For example, in databse "D1