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 you have available in the source server
• Don´t forget to backup your wordpress files/images

From PHPMyAdmin

1. Access your DB

2. Navigate to Export -> Select ¨Quick” and ¨Go¨

3. You will have a .sql file downloaded

From Command Line

1. Access your server where you are migrating from

2. Create WordPress database backup

mysqldump -u [user] -p [database_name] > your_backup_name.sql

3. Create WordPress files backup

tar -zcvf your_file_name.tar.gz /target/directory

4. Restore WordPress DB on the new server

mysql -u [user] -p [database_name]

5. Restore WordPress files on the new server

tar -zxvf [archive_name].tar.gz --directory [target_directory]