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 diffe
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 w
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 m
