[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
[box type=”warning”] Don’t put space after -p and then password[/box]