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
