How do I export and import a mysql database?

Export a mysql database to a file:

mysqldump -u {database_username} -p {database_password} {database_name} > {filename}.sql

Read in a database export:

mysql -u {database_username} -p {database_password} {database_name} < {filename}.sql