How to Export A MySQL Database Structure



If You need to export only the MySQL database’s tables’ structures use –no-data switch.

mysqldump -u username -ppassword –no-data database_name > dump.sql
Don’t put space after -p and then password

Leave a Reply

Your email address will not be published. Required fields are marked *