File this under “Useful things to remember”.

The following bit of command line magic will export the schema of your database.

mysqldump --no-data --tables -u YOUR_USER_NAME -p DATABASE_YOU_WANT_SCRIPTED >> FILENAME.sql

An example looks like this:

mysqldump --no-data --tables -u larry -p contacts >> contacts.sql
If you want the data as well, omit the “—no-data” portion.