[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]