MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jens-Petter Salvesen Date:January 30 2003 11:12am
Subject:RE: mysqldump, exclude table?
View as plain text  
Actually, you might want to play with sed or perl.

mysqldump -u root --no-create-info -q --all-databases | sed s/'INSERT INTO

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'

If you are on windows, I believe you will find some port of sed for that
platform as well.

best regards,


-----Original Message-----
From: Paul DuBois [mailto:paul@stripped]
Sent: 30. januar 2003 03:27
To: mysql@stripped
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
>something like:
>mysqldump -ume -psecret -hserver --all-databases
>   --exclude-tables=server.acctlog


>mysql, sql, query, sql, sql, sql

Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <mysql-thread131199@stripped>
To unsubscribe, e-mail
Trouble unsubscribing? Try:
mysqldump, exclude table?Ray29 Jan
  • Re: mysqldump, exclude table?Paul DuBois30 Jan
RE: mysqldump, exclude table?Jens-Petter Salvesen30 Jan