How to dump table structure only from mysql

Question

Dump just the table structure to a file in MySQL

Answer 1

Syntax:

mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql

The only option that is different than creating an entire backup is the -d switch, which tells mysqldump not to output the data.

Example:

mysqldump -d -h localhost -u root -p1234587ssd databasename > dumpfile.sql