WP Migrate DB

WP Migrate DB

Migrates your database by running find & replace on URLs and file paths, handling serialized data, and saving an SQL file.

4
WPMeta Score

Did you know?

Plugin Popularity 4.7
Author Activity 2.5
  • 👷🏻 This plugin is actively maintained and contributors are really committed to it!
  • 🏂 Super good!! 84.23% users from more than 300,000 active installs are on the latest version!
  • 🎖 Definitely a good plugin. This is one of the Top 500 plugins.
  • ❤️ Mindblowing! More than 1,191,350 people use plugins from this team.
  • 📥 Seems like a popular plugin - 592 people download this plugin everyday.
  • 👨‍👨‍👧‍👧 It takes two to tango! We found two people behind this plugin.
  • 📢 Aweful or Awesome?? 30 total updates and 30 in just last 12 months. That's a lot!
  • 🎂 This plugin is going to celebrate it's 12th anniversary after 9 months.

Key Numbers

  • 300,000+ Active Installs
  • 4.6 Avg. Users Rating
  • 214 Total Ratings
  • 2,426,546 Total Downloads
  • 2009-12-13 Added
  • 30 Releases in 12 Months
  • 2019-04-30 Last Update
  • 1.0.11 Current Version

Peer Comparison

# Plugin WPMeta Score Users Rating
1WP Migrate DB4300,000+4.6
2Easy WordPress Migration: Migrate Guru2.720,000+4.9
3WordPress Migration & Duplicator1.14,000+4.4
4CMS2CMS Connector11,000+3.7
5WP Synchro – Migrate WordPress database and files0.91,000+5
6WP Migrate DB Anonymization0.9200+0
7Contact Form7 Database0.8600+0

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

Compare pro vs free →

See the video below or visit the web site to learn more about the pro version.

Gallery

Contributors

bradt
deliciousbrains

Reviews

5 Stars 187
4 Stars 3
3 Stars 0
2 Stars 5
1 Star 19
Good but very limited
by
The free version doesn't give you enough features for it to be of any actual use because the import, pull and push options are disabled. If you don't allow imports then you may as well use a UI like phpMyAdmin for the export because you'll need it for the import anyway. The plugin has a lot of potential but the premium version is way overpriced if you just want one site like myself, so the free version is the only option and doesn't give you the right tools to do anything productive with it.
Not a complete plugin
by
This plugin does only half of expected. If i need to pay for import, then this free version is useless for me. Maybe you could keep the basic functions for free as migration means export+import.
A Taster of Why The Premium Version is Worth Purchasing
by
I'll admit I may have found a similar solution on Git Hub, which after 6 months of constant errors and long migration times, I decided to purchase Migrate DB Pro. After just one migration, I wish I'd purchased the Pro version of this plugin 6 months ago. Migrate DB Pro has additional features that avoid issues caused by alternatives and the migration time was incredibly quick in comparison. Even faster when using their CLI Add On. A massive time saver!
Outil simple et efficace pour faire une sauvegarde de BD
by
Il fait son job à merveille.
Used to be great. Now its export only
by
The find replace works pretty well as you import databases. However, it is now only in the paid tier. :/ Consider using Peach which is a free, open-source web migration tool on github under psaia/Peach
Free = useless / Pro = usefull
by
This plugin used to be very nice. Since they removed the 'import' feature from the free version, the 'free' version has become obsolete. (Pro version should still be good though)
Don't believe the hate, it works perfectly!
by
The two negative reviews below are mind blowing, especially one by 'Phil Emery'. I've used it and it clearly specifies that you will download the modified dump, you actually have to tick another field to go live on the DB and it WARNS you. Phil Emery: take responsibilities for not knowing what you are doing, this plugins works perfectly. So the review...it just works, has made the whole process of deploying to a production environment easy, quick and SAFE. Interface is easy to use and allows you save profiles, free version is packed with features, love this plugin.
Terrible
by
You would think it would do a find and replace on the database that it's exporting, but it actually does it on the live db (first, I guess) Better have a good backup or your f***ed
Just a commercial for the paid version - Pass it up.
by
You can export the db in the free version, but no import??? The only reason why I'm writing this review is to express sheer shock at the UI when I first realized this. I looked around for a few minutes thinking the problem is in me, not in the tool/UI. This plugin has no point being in the WordPress store, it's purely a commercial for the pro version. I am bewildered by the amount of 5* it has received, and frankly, I don't see the reason. Well, to be honest, I'm not surprised, astroturfing is a thing. Anyways, there are much better plugins out there, pass this one up, anybody who needs an advanced tool can easily work on this without a plugin like this (or with some of the much better ones in the store).
It Just Works! (Sighs in relief...)
by
Having been through the staging and migrating ringer this last week it was refreshing to install a plugin, connect two sites and watch as one was copied to another, no fuss, no errors, just copied and working. The caveat is, this plugin is all but useless if you don't buy a subscription*, but nothing else, free or paid for has worked with such ease. I moved my hosting from WP Engine (too expensive) to my own servers on Azure and AWS. I wanted to keep some of the functionality of WP Engine so have been looking for a reliable staging plugin amongst other things. Manually moving a database to a staging domain is too much stress, so I tried paid versions of Revmakx's staging tool in InfiniteWP (too many options and it just 500 Errors everything it touches), All in One WP Migrate (Paid $165 for Unlimited and OneDrive plugins, got a crash, a hang, something not copied, 8 hours wasted, refund), Duplicator (Free, just couldn't make it work), looked at WP Staging but it stages to the same database, no thanks and finally restoring backups etc. or anything else that looked possible. Nothing worked. Finally, I went back to the first thing I looked at, WP Migrate DB Pro. I had passed it up as at $249 / year for a dev license it is pricey. But my god, it's good. Slick as a goose fat sandwich in a pool of bacon lard. It'll save me hours in creating staging sites and moving them live and back again. Just, thank you! *I am using Delicious Brains SpinUpWP for one of my servers that doesn't have access to phpMyAdmin so direct DB access is proving tough at the mo!

Keywords

  • backup
  • data dump
  • database
  • export
  • migrate
  • migration
  • mysql

Was this useful?

Would you recommend this plugin summary to your friends?

Try these other plugins too...