MySQL - Export and import a database

Export a MySQL database:

mysqldump -u{username} -p{password} {database} > {export_filename}

Import from a MySQL database dump:

mysql -u{username} -p{password} {database} < {export_filename}