mysqldump except one table

--------------020200080703090103070700
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------020200080703090103070700--

Re: mysqldump except one table

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 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
>






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysqldump except one table

--00032557a2ba28ccb6049a1e68d4
Content-Type: text/plain; charset=ISO-8859-1

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 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
>

--00032557a2ba28ccb6049a1e68d4--