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
At 11:09 -0600 1/29/03, Ray wrote:
is they a way to have mysqldump ignore a list of tables, but get everything
else?
something like:
mysqldump -ume -psecret -hserver --all-databases
--exclude-tables=server.acctlog
No.
--
mysql, sql, query, sql, sql, sql
To: [EMAIL PROTECTED]
Subject: Re: mysqldump, exclude table?
At 11:09 -0600 1/29/03, Ray wrote:
is they a way to have mysqldump ignore a list of tables, but get everything
else?
something like:
mysqldump -ume -psecret -hserver --all-databases
--exclude-tables=server.acctlog
No.
--
mysql, sql, query