There are many cases where you might need to migrate your WordPress database. Whether it is to set up a staging site, update an existing one or create a local installation of a live project. WordPress options and meta are serialized and stored in the database making such migrations a bit more complex than a simple search and replace, but don’t worry, there’s a plugin for this!
WP Migrate DB
This plugin makes database migration a breeze. It will export your database, run a search & replace to replace the old URLs with the new ones and handle data serialization while doing it. What you will get is an SQL file ( or a gz one if you enable compression ) which you can then import to the destination server using phpMyAdmin, MySQL command line or any other tool that allows you to import the database on your server. That’s it. Additional plugin options allow you to exclude spam comments, transients, post revisions and more.