If you need the table definitions as part of your dump, you could truncate those tables right before you run mysqldump then restore the data right after you finish.
If you can get rid of them during the dump, then: drop your temp tables, do a full database backup, re-create your tables. If you would rather not need to rebuild the data in your temp tables, you could just move them temporarily into a different database (use RENAME TABLE to make them part of a different database), do your backup, then re RENAME them back into your original database http://dev.mysql.com/doc/mysql/en/RENAME_TABLE.html I also like to get two separate backups, one with only the table structures in it and another one with just the data. That way I can have a documentation of my schema that is not intermixed with the table data. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Shannon R." <[EMAIL PROTECTED]> wrote on 10/12/2004 12:31:18 PM: > > Is there a way to tell mysqldump to dump all tables in > the specified database except certain specified > tables? > > Like maybe: "mysqldump dbname !exclude_this_table > > data.sql"? > > I have about 200 tables in my database and I only need > to back-up about 98% of them. The other 2% are HUGE > temporary search index tables which can be rebuilt > anyway in case the dump has to be retored. > > > Ideas anyone? Thanks! > Shannon > > > > > > _______________________________ > Do you Yahoo!? > Declare Yourself - Register online to vote today! > http://vote.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
