Re: mysqldump except one table

2011-01-18 Thread 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 diffe

Re: mysqldump except one table

2011-01-18 Thread 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 w