• Home
  • About
  • Fav Books
  • Tools
  • Journal
  • Hire Me
  • Contact
Small Biz Geek

Small Biz Geek

Small business design, marketing & technology issues

Website design services

A journal on small business design, marketing & technology

Follow @twitterapi
  • The Internet
  • Marketing
  • Graphic Design
  • Web Dev
  • Web Design
  • Social Media
  • Technology
  • Miscellaneous

WP Migrate DB – Free WordPress Database Migration Script

You are here: Home / Darren’s Small Biz Tools / WP Migrate DB – Free WordPress Database Migration Script

WP Migrate DB

WP Migrate DB is a free WordPress script that runs in the dashboard as a plugin and creates a database dump while changing all the URLs and handling serialised data strings.

You can save the database file to your computer as a gzip .SQL file and then import it into the destination website via a database management tool like the popular GUI phpMyAdmin or, if you prefer, the SSH tool PuTTY.

phpmyadmin-import-database-success

It’s helpful for developers wanting to clone a WordPress website to a localhost such as WAMP or vice versa. WP Migrate DB has solved a nasty database issue I had concerning serialised data when my normal method of cloning/migrating took a bad turn. 

I’ll come on to my litigant of database complaints in a moment and how I got around them.

Below is the video provided by the makers of the plugin. This is a pretty straight forward scenario: 

Watch video on YouTube

Database Issues & Discovery of WP Migrate DB

Usually, I build new client websites locally using WAMP, clone the database, replace the URLs, copy the website folder directory and install everything to the destination server.

This is what I call the manual method of exporting the .SQL from phpMyAdmin.

On this occasion, I had built the WordPress site WAMP (as per usual) but wanted to clone everything into an InstantWP installation for my client.

I followed common procedure and tried to replace the database URLs, as per usual, using the free script Search Replace DB without breaking serialised data.

Search and replace database URLs

All that needed to be done was to change the URLs from http://localhost/websitetest to http://127.0.0.1:4001/wordpress

WordPress Text Widgets Wiped Out

For some reason, on this occasion, the Search Replace DB script went wrong. The WordPress text widgets were wiped out on the destination server.

Everything else was there except text widgets in the header, sidebar, footer.

It wasn’t as though they’d been relegated to the “inactive widgets” area either, as is often the case when switching WordPress themes. The widgets simply weren’t there.

The data pertaining to them WAS still in the .SQL file which meant serialised data had ben broken for text widgets in the course of me running the SRDB script previously mentioned.

WP Migrate DB would be the answer.

Old URL > New URL

WP Migrate DB will find and replace all URLs in your database as well as unserialising and reserialising. This is taken care of before the database dump actually takes place. 

Any serialised data pertaining to text widgets is handled as a result. 

Wp Migrate DB

If you’re migrating a https website to your localhost, be sure to enter http: in the replace field.

If you don’t you’ll end up with a database full of URLs that look like https://localhost/yoursite and your site will not load in the localhost.

It seems WP Migrate DB is a fantastic choice and allows me to clone any WordPress website database on either a localhost or remote server and reproduce wherever I want.

But as you know, it depends on your “rig” – there are seemingly infinite combinations of software with WordPress and situations can differ hugely.

Download the plugin:

https://wordpress.org/plugins/wp-migrate-db/

Share this page:

Search Website

About the Webmaster

Hello, my name is Darren, a 34-year-old business enthusiast eager to learn and do good work.

I’m a website builder for hire working with small to medium businesses.

I network in Derby, Ilkeston and Nottingham in the East Midlands, England.

Read my story

Let’s Connect

YouTube
Follow me on G+
Follow me on Twitter



I'm active on the three social networks listed above.

Twitter is the one I use most.

Recommended Books

Don't Make Me think - Steve Krug

“Don’t Make Me Think: Revisited” – Steve Krug (Book Review)

A person of average technical ability must be able to navigate your website easily. This is required reading for anyone wanting to create a better experience for their visitors…

Latest Journal Entries

  • CEOs, Stop Using “Poverty Porn” for your Awful Social Media PR Stunts! FFS!
  • Childhood Business Ventures: What Was Yours?
  • Local Business Websites: “About” Pages Done Right Will Attract and Delight Readers
  • Magazine Advertising Scam: Rogues Impersonate Crime Prevention Officers
  • Privacy and Data Protection is a Matter of Life and Death for Some
  • Magazine Advertising Scam: Bogus Children’s Cancer Charity Misleading Small Businesses
  • UK Businesses Electronically Processing Data Are Legally Required to Register with the ICO
  • Stolen Credit Card Email Scam Targets Small Businesses and Service Providers
  • Nuisance Calls, Emails and Empty Promises: The Bungling Incompetence of Yell.com
  • “Don’t Make Me Think: Revisited” – Steve Krug (Book Review)
  • How to Hit Back (Gracefully) Against Fake Negative Google Reviews
  • How Safe Is Your Password from the $450 Billion Cybercrime Industry?

Primary Navigation

Home
About Darren
Good Books
My Tools
Blog Posts
Hire Me
Contact Me

Secondary Navigation

The Internet
Marketing
Graphic Design
Website Development
Website Design
Social Media
Technology
Miscellaneous

Derby & Nottingham Area

Small Biz Geek
Office 897
109 Vernon House
Friar Lane
Nottingham
NG1 6DQ

Telephone

Tel: +44 (0) 115 714 3290
Tel: +44 (0) 7951 897 243

VoIP

Skype: ilkestonwebdesign
WhatsApp: 07519 897 243

Email

d...@smallbizgeek.co.uk

Let’s Connect

Twitter
Google +
YouTube
Soundcloud
LinkedIn
RSS

Subscribe to Blog by Email

Subscribe to Blog By Email

Social Calendar

UK Small Business Twitter Chats
#SmallBizHour on Twitter
Derby & Nottingham Meet Ups
WordPress Nottingham Meetup
WordPress Derby Meetup
Genesis Framework by StudioPress


Copyright © 2019 · Small Biz Geek · Privacy Policy · Commenting Policy · Website Disclaimer · ICO number: ZA305900


Written and designed by Ilkeston Web Design

This site uses cookies More info