MySQL – Move Database

Recently I had to move several MySQL databases around. I just wanted to make note of the commands here.

mysqldump -uroot -p [DB_NAME] > file.sql

mysql -uroot -p [DB_NAME] < source file.sql