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.

#1
#2
#3
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!!

0 Comments

Leave a Reply