Re: mysqldump exclude table option

2004-10-12 Thread SGreen
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

mysqldump exclude table option

2004-10-12 Thread Shannon R.
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