Note : if you table name it will export all tables from given database; eg:* mysqldump -u user -ppassword wordpress --no-data > Dumpdata.txt *
It will export all tables from db wordpress. On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar <aim.prab...@gmail.com>wrote: > use can use mysqldump with option *-no-data* > eg. > *mysqldump -u user -ppassword wordpress user --no-data > Dumpdata.txt * > > where wordpress is my database and user is my table. > > Thanks > > > On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green <shawn.l.gr...@oracle.com>wrote: > >> Vikram A wrote: >> >>> Hi, >>> >>> I would like to export my table structure from MYSQL from a particular >>> db. Is there any tool for doing this? >>> >> >> There are several ways to get "structure" information from within MySQL: >> >> the SHOW COLUMNS... command >> the SHOW INDEXES... command >> the SHOW CREATE TABLE... command >> >> you can also write queries against the tables in the INFORMATION_SCHEMA >> >> You can also use an external utility such as mysqldump. Use the --no-data >> option to get just a dump of your table definitions. If you also want to see >> triggers and events and stored procedures, you also need to use the >> --triggers, --events, and --procedure options, too. >> >> Details are in the fine manual: >> http://dev.mysql.com/doc/refman/5.1/en/show.html >> http://dev.mysql.com/doc/refman/5.1/en/information-schema.html >> http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html >> >> I guess the final answer depends on which information are you looking for >> and in what format you want to see it. Got any details you want to share? >> >> -- >> Shawn Green >> MySQL Principle Technical Support Engineer >> Oracle USA, Inc. >> Office: Blountville, TN >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com >> >> > > > -- > Best Regards, > > Prabhat Kumar > MySQL DBA > Datavail-India Mumbai > Mobile : 91-9987681929 > www.datavail.com > > My Blog: http://adminlinux.blogspot.com > My LinkedIn: http://www.linkedin.com/in/profileprabhat > -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
