How to Export your MySQL database schema to a file using the Command Line?

Question: How to Export your MySQL database schema to a file using the Command Line?

Answer: 

Use the following command in the Command Line Interface

mysqldump --no-data --tables -uMYSQL_USER_NAME -pMYSQL_PASSWORD MYSQLDATABASE >> FILE_NAME.sql

Replace MYSQL_USER_NAME with your username,  MYSQL_PASSWORD with your password, MYSQLDATABASE with the database name you want to export and FILE_NAME.sql with the file that you wish to export the schema to.

• Add New Search
• Comments

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.