Reading Time: < 1 minute

Hi All, this document deals with how to get database structure.
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language

How to perform


mysqldump -d -u username -p databasename > dumpfile.sql

The above command creates a .sql file with database and table structure without data.

-d means no data

or else you can use the below command,


mysqldump --no-data -u username -p databasename > dumpfile.sql

© 2020, Techrunnr. All rights reserved.

Questions Answered
Articles Written
Overall Points

Prabhin Prabharkaran

He is Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!!


Leave a Reply