Re: mysqldump except one table

[jayabharath]

you can use "--ignore-table" option for this,

mysqldump -u  -p dbname --ignore-table=dbname.tablename > xyz.sql
you can use this option multiple times to ignore multiple tables.

Rgds,
Jay
On Tue, Jan 18, 2011 at 6:18 PM, Adarsh Sharma wrote:

> Dear all,
>
>
> I am researching about different parameters provided by the *mysqldump*
> utility.
> It provides a method to dump databases with all tables.
>
> My problem is I want to dump a database having 30 tables except one table
> i.e i have to dump only 29 tables.
>
> Is this possible ?
>
> Please guide me how to do this.
>
>
>
>
> Thanks & Best Regards
>
> Adarsh Sharma
>

Re: mysqldump except one table

[a . smith]

Check the manual? Its here under ignore-table

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Quoting Adarsh Sharma :


Dear all,


I am researching about different parameters provided by the  
*mysqldump* utility.

It provides a method to dump databases with all tables.

My problem is I want to dump a database having 30 tables except one  
table i.e i have to dump only 29 tables.


Is this possible ?

Please guide me how to do this.




Thanks & Best Regards

Adarsh Sharma








--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org