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
Check the manual? Its here under ignore-table
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Quoting Adarsh Sharma adarsh.sha...@orkash.com:
Dear all,
I am researching about different parameters provided by the
*mysqldump* utility.
It provides a method to dump databases with all
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 adarsh.sha...@orkash.comwrote:
Dear all,
I am
hi
i want to dump the contents of one table into a text
file ... can you tell me what i've done wrong ?
i tried :
mysqldump --opt --tables studenttable myfile.txt
mysqldump --opt --databases [studenttable] myfile.txt
mysqldump --opt database [studenttable] myfile.txt
but all