MySQL Dump and Recreate

Here's a little post so I don't forget to dump and recreate a MySQL database.

To dump a database:

$ mysqldump -uroot -ppassword mydb > mydb.mysql

To recreate the database:

$ mysqladmin -uroot -ppassword drop mydb
$ mysqladmin -uroot -ppassword create mydb
$ mysql -uroot -ppassword mydb < mydb.mysql