How can I get a dump of all tables DDL?

mysqldump command line tool is used to dump all tables in databases managed by SQL and migrats the data to another server. 

To dump the table structure for all tables in database:

mysqldump -d -u username -ppassword mydatabase > mydatabase_dump.sql

-d -> not to include data in the dump 
-u -> username
-p -> password
mydatabase_dump.sql -> dumping the structure to a file.
There should be no space between -p and password

To dump a single table from your database.
 
mysqldump --no-data -u username -ppassword mydatabase tablename
 
--no-data can be used instead of -d

To dump a multiple table from your database.
 
mysqldump -d -u username -ppassword mydatabase tablename1 tablename2 tablename3

To create same table in another database:
 
mysql -u username -ppassword newdatabase < mydatabase_dump.sql

Hi Dhawan,

You can "get a dump of all tables DDL" using the mysqldump command line utility:

1. mysqldump -d -u  -p -h    

The -d option means "without data".

For more detail you can refer below article:

• How to generate DDL for all tables in a database
• https://stackoverflow.com/questions/6597890/how-to-generate-ddl-for-all-tables-in-a-database-in-mysql/6597966

Hope, this will help you!