WP Migrate DB exports your database as a MySQL data dump (much like phpMyAdmin), does a find and replace on URLs and file paths, handles serialized data, then allows you to save it to your computer as an SQL file. To complete the migration, you need to use a database management tool (e.g. phpMyAdmin) to import the SQL file to your database, replacing your existing database. It is perfect for developers who need to migrate fresh data from the production site to their local install, or migrate their locally developed site to a staging or production server.
WP Migrate DB handles serialized data (both arrays and objects) by unserializing the data and going through it, identifying strings and running a find & replace on them. Once it has gone through all the data, it serializes it again and sticks it back in the database.
PRO Version with Email Support and More Features
- Push and pull your databases
- Find & replace that handles serialized data
- Export your database
- Select which tables to migrate
- Filter out post types
- Exclude useless data
- Save migration profiles
- Phenomenal email support
- Stress tested on massive databases
- Solid security
- Media Files addon
- CLI addon
- Multisite Tools addon
See the video below or visit the web site to learn more about the pro version.