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