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.


  • 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


3. Create WordPress files backup


4. Restore WordPress DB on the new server


5. Restore WordPress files on the new server

Leave a Reply

Your email address will not be published. Required fields are marked *