Once in a while, you are forced to migrate your site to a new location. The process can be time-consuming and complicated if you don’t know what you are doing. You certainly don’t want to miss any steps and end up with broken images and links. WP Migrate DB is a free plugin that makes it easy to export your database as a MySQL data dump. It can also find and replace URLs and file paths.
WP Migrate DB lets you select the tables that you want to migrate. You can use it to push your local DB up to replace production/staging DB. It also supports media files migration. What’s neat is you can do a find & replace on URLs without having to write SQL queries yourself.
WP Migrate DB is a free plugin designed to make it easy to migrate your DB. As always, make sure you have all your data backed up before trying anything crazy.