How to Migrate a WordPress MySQL Database

I very often have to migrate MySQL Databases as I like to spend some time playing with Wordpress. So here is an easy and quick way to migrate your DB and avoid manual work when moving a blog from different providers/servers. Pre-Requisites You must have a pre-configured MySQL server, database and user already created in the destination(new) server You can either use command line or PHPMyAdmin if...