From: Claudio Nanni
Date: June 8 2011 8:31am
Subject: Re: mysqldump --ignore-table
List-Archive: http://lists.mysql.com/mysql/225209
Message-Id: <BANLkTinMNaBinQ-J_RNS8=jyBox2Gz67BQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf3054ab59c326c604a52f2992

--20cf3054ab59c326c604a52f2992
Content-Type: text/plain; charset=ISO-8859-1

Hi Daniel,

you can use a workaround from the shell,

cd /path/to/your/database  (e.g.: cd /var/lib/mysql/mydb)

ls -al *table** | awk '{print $8}' | awk -F"." '{print "--ignore-table=*mydb
*."$1}' | xargs mysqldump -u*root* -p*toor* *--your-flags **mydb*

It's not that beautiful but it should work.

Claudio

2011/6/8 zia mohaddes <zia.simab@stripped>

> Dear all,
>
> I am currently trying to figure-out how I could ignore multiple tables in
> mysql using a simple a regex. For example I have multiple tables which have
> the following structure: mytable1, mytable2, ..........,mytable100. And I
> would like these tables to be ignore when doing mysqldump by doing
> something
> like this:
> mysqldump --ignore-table = mydb.table*
>
>  I am wondering if there is any way do something like this in mysql!
>
>
> Thank you kindly for the help,
> regards,
> daniel
>



-- 
Claudio

--20cf3054ab59c326c604a52f2992--