List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:June 8 2011 8:31am
Subject:Re: mysqldump --ignore-table
View as plain text  
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

Thread
mysqldump --ignore-tablezia mohaddes8 Jun
  • Re: mysqldump --ignore-tableClaudio Nanni8 Jun