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 li
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
- 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 th
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
