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 `smalltables.php` > .... The script runs "show tables" and filters out those that I don't want to back up. By using an exclusion list, I don't have to add new tables to the list very often. Jeff; On Tue, 31 Aug 2004 15:23:35 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said: > 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 except two. > > > >For example, in databse "D1", I have 10 tables, I'd like to dump 8 > >of them at one time. > > On the mysqldump command, name the database followed by the 8 tables you > wnat to dump. > > You cannot say "dump all but ..." > > > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
