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
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 searc