Re: mysqldump all tables except 2 in a database

2004-09-01 Thread SGreen
- 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 except two in a database. I know we have the way only dump schema, only data

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,

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

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 except two in a database. I know we have the way only

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