↑ Return to D20 Server Migration

PRIV D25 WP Migrate DB


Page no: D25

Information: wordpress.org/

 

Description

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.

Example: s:5:"hello" becomes s:11:"hello world"

PRO Version with Email Support and More Features

  • Push and pull your databases
  • Find & replace that handles serialized data
  • Backups
  • 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

Screenshots

main screen

Settings Tab

Exporting

Using WP Migrate DB we did a simple Search & Replace task, which goes through all of the tables and make a simple Search & Replace.

You can monitor the process during the execution and see the result real time.

See more for D2x Server Migration