List:General Discussion« Previous MessageNext Message »
From:jayabharath Date:January 18 2011 12:54pm
Subject:Re: mysqldump except one table
View as plain text  
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.sharma@stripped>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
>

Thread
mysqldump except one tableAdarsh Sharma18 Jan
  • Re: mysqldump except one tablea.smith18 Jan
  • Re: mysqldump except one tablejayabharath18 Jan