Often times you will need to dump your MySQL database from one machine to another. Sometimes you can use utilities like PHPMyAdmin, but it’s always useful to know how to dump your database’s contents manually.
add3-imac:~ jon$ mysqldump -u username -p databasename >/tmp/databasename.sql