I would use the --tables option of mysqldump. It accepts more than one table name, so all you need to do is make a list of the tables you want dumped. If you are combining --tables with other options (like -B/--databases or -u or -p) make sure the --tables option is the LAST parameter in the list as everything that occurs after it will be considered a table name.
details here -> http://dev.mysql.com/doc/mysql/en/mysqldump.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Rhino" <[EMAIL PROTECTED]> wrote on 08/31/2004 05:57:50 PM: > > ----- 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 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", I have 10 tables, I'd like to dump 8 of > > them at one time. > > > You haven't said which version of MySQL you are using or what operating > system you are running so this may not be much use to you. > > I am running MySQL 4.0.15 on Linux Mandrake 8.2. A bash script I posted > earlier today could probably be adapted to do what you want. It acquires the > names of all of the databases and takes backups of them; all you'd have to > do is add an 'if' statement that excluded the two databases that you didn't > want to dump. > > I have attached the script again to this note since it is rather hard to > read when it is wrapped in the email editor. > > Let me know if you have any questions about the script. > > Rhino > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]