you can use "--ignore-table" option for this, mysqldump -u xxxx -pxxxx 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 <adarsh.sha...@orkash.com>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 >
