Actually, you might want to play with sed or perl. mysqldump -u root --no-create-info -q --all-databases | sed s/'INSERT INTO acctlog'.*//
is a first draft, although perhaps not optimal in speed. It will remove all acctlog inserts from all databases. You might want to play a bit with shell scripting if you need to remove acctlog inserts from only the 'server' database. If you are on windows, I believe you will find some port of sed for that platform as well. best regards, Jeppe -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 30. januar 2003 03:27 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, sql, sql, sql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php