how to get database structure1 min read

Prabhin Prabharkaran Administrator
DevOps Engineer

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

follow me

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

Related posts

Leave a Reply