There is an option to ignore tables from being dumped
--ignore-table=*db_name.tbl_name* Do not dump the given table, which must be specified using both the database and table names. To ignore multiple tables, use this option multiple times. so you would say #mysqldump -u<user> -p<password> --ignore-table = db_name.tbl_name db_name Kishore Jalleda http://kjalleda.googlepages.com/ On 4/25/06, Philippe Poelvoorde <[EMAIL PROTECTED]> wrote: > > Hi, > > I've read the manual, but it seems there is not the option I'm looking > for. > I would like to dump all tables but one. Is that possible ? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >