Better Tools Make Better WordPress Developers

The 13th century French proverb “mauvés ovriers ne trovera ja bon hostill” roughly translates to “a bad workman will never find a good tool.” I’m sure at the time this proverb applied to stone masons and carpenters. Few would have imagined that it would also apply to web developers pushing bits around on a screen centuries later.

It’s unlikely that you are “a bad workman.” You are reading this article afterall. You’re probably looking for a new tool to help you with WordPress development. High performing web developers don’t do that.

In his reveting WordCamp San Diego 2013 talk, the “Done Done” man himself, Chris Lema describes the search for better tools as one of the keys to being a high performer.

High performing WordPress developers actively look to improve the tools in their belt. If a tool could help them but doesn’t exist, they build it. It’s in their nature. It’s an itch that gets worse with time and eventually needs to be scratched.

Think Linus Torvalds with Git. Or in the WordPress world, Scribu with posts-to-posts and wp-cli.

Ideally when you go fishing for a tool, you hook yourself an awesome one that already exists and you can start using it right away. Today, I just so happen to be releasing a tool that you may have been fishing for already but came up empty.

Introducing WP Migrate DB Pro

WP Migrate DB Pro is a pro (paid) upgrade to the popular free plugin WP Migrate DB. The free plugin has been available on WordPress.org since 2009 and has gained in popularity in recent years, receiving lots of enthusiastic reviews from developers.

Enthusiastic Review

The free plugin allows you to export your database, does a find and replace on URLs and file paths (handles serialized data), then allows you to save it to your computer.

The pro version includes this feature, but also enables you to select which tables you’d like to export, do more find and replacing, and shows progress as the export runs.

But the big new feature in the pro version is the ability to push and pull the database from one WordPress install to another. With the free plugin, you need to manually import the exported SQL file. Pushing and pulling eliminates this step, saving you from messing around with phpMyAdmin or the command line. This is the time savings high performers are always looking for.

Anyways, enough talk, let’s see the goods. The following video shows how effortless it is to update a local development database with the data from a live site using this new plugin:

Launch Special – Get 20% Off!

We’ve created an exclusive coupon code for WP Daily readers. Simply enter WPDAILYLAUNCH at checkout and receive 20% off the regular price. Offer expires April 30. Buy Now

  • http://www.rezzz.com Jason Resnick

    Looks awesome! What kind of network connection protocol is the pull/push request using? I tend to only allow the MySQL user access via a certain host. Also, if a server only has SFTP open, can this be done?

    • http://bradt.ca Brad Touesnard

      Hi Jason, it actually works all over HTTPS or HTTP. You install the plugin on two sites and then they talk to each other and send data to each other. No need to open ports or anything like that. Let me know if you have any other questions. :)

      • http://www.rezzz.com Jason

        Very cool — I’ve been using my own wp-cli home cooked scripts but this has sparked some ideas for things that I’ve had on my plate.

      • http://13m2.nl Andre

        So, if it works over HTTP it works on sites that are hosted on shared hosting too?

        And could you install it on three sites, say a localhost, staging server and a live site?

      • http://bradt.ca Brad Touesnard

        Yep, should work over HTTP and HTTPS on shared hosts.

        From our FAQ:

        Typically, WP Migrate DB Pro is installed on two environments (e.g. development and production). It’s the same site but two different URLs (e.g. http://mysite.com and http://dev.mysite.com). So we actually consider a “site” to be two unique URLs.

        http://deliciousbrains.com/wp-migrate-db-pro/pricing/#faq

        • http://13m2.nl Andre

          OK thanks,

          I read that bit of the two environments, so that’s why I asked about the three environments.

          Anyway, I bought the plugin so I can try it out.

          Moving DB’s back and forth between test and live sites can be a bit of a pain, so a solution that makes this easier and less error-prone is very welcome.

          Cheers

        • http://13m2.nl Andre

          That was easy..

          Very smooth, this is going to save me a lot of time.

          Brilliant!

  • Richy

    Video is not working?

    • http://john.do/ John Saddington

      i see it working.

    • http://bradt.ca Brad Touesnard

      Yep, working for me too.

  • http://www.xp3.us Holger

    “Un mauvais ouvrier ne trouvera jamais un bon outil”. I do not speak French at all, I just asked a friend in France ;-)

  • http://www.ihatetomatoes.net Petr

    I have been using WP Migrate DB for a while now and it’s been definitely very useful plugin. Will check the pro version features on my next project and site migration. Thanks Brad.

  • http://fxbenard.com FxB

    This tool seems to be nice, but my french eyes get hurt by your translation.

    Google translate might be your friend at first and tell you :

    “un mauvais ouvrier ne trouvera jamais un bon outil”.

    but if you want to keep the real translation it should be :

    “À mauvais ouvrier, point de bon outil”.

  • Rohith

    I just bought this plugin(personal version) and had a question about the 2 sites that i’m entitled to use. One is my main live server, and the other place i want to export is from my localhost on my local machine. Will the localhost site use up one slot from the 2 sites that i’m entitled to?

    I really hope it doesn’t as i shuffle between my mac and pc and they both have different port config setup at the moment ( localhost and localhost:8888) and i’d rather not be limited to only one machine that i can use this tool from. I know i can set it up so that the localhost addresses match, but still, i’m hoping localhost addresses don’t count.

    Thanks for the great plugin, I’m about to give it a whirl now.

    • http://bradt.ca Brad Touesnard

      Rohith,

      This is from our FAQ:

      What counts as a “site”?

      Typically, WP Migrate DB Pro is installed on two environments (e.g. development and production). It’s the same site but two different URLs (e.g. http://mysite.com and http://dev.mysite.com). So we actually consider a “site” to be two unique URLs.

      So, with your Personal license, you can use it on 4 unique URLs.

TOP