Migrating a WordPress site

DezUk · 26 Mar 2015 at 20:06

I have been working on a WordPress site for a client and have finished the site on my own web hosting package. I have created a new hosting package on Fasthosts at the request of the client and now I need to export the site from my server to the new server, not something I have done before.

I have quite a few custom plugins, widgets and a customised paid template and obviously I want to keep everything as is without anything breaking.

I see in the admin panel there is an option Tools > Export but this only covers comments and posts etc. So can anyone point me in the direction of how to best export the entire database and site settings/content and then import it to the Fasthosts account?

Cheers!

DezUk · 26 Mar 2015 at 20:14

I have cPanel on my own server which is Vidahost but not sure on Fasthosts as waiting on the domain transferring before I can setup a website instance but I believe its cPanel their as well.

DezUk · 26 Mar 2015 at 22:36

Cool I'll check that out

DezUk · 28 Mar 2015 at 18:00

Thanks for all the help, got the database transferred over and the wp site is working but still one major issue. When I click any of my links they are still pointing to my old install on my own server. Just emailed the client to say its live and then noticed this so need to fix it asap.

See http://nelsongray.com/ and try clicking ay of the menu links and you will see its directs to my cruitme.com domain

Hoping this is an easy fix?

DezUk · 28 Mar 2015 at 18:02

I also used searchreplacedb2.php to search and replace after following this guide

Result:
In the process of replacing "http://cruitme.com/projects/nelson/" with "http://nelsongray.com/" we scanned 18 tables with a total of 4581 rows, 1645 cells were changed and 1024 db update performed and it all took 0.901613 seconds.

DezUk · 28 Mar 2015 at 19:09

I have just copied it all over again and setup the database again thinking that might fix it but same result. I would try that plugin but when I go to www.nelsongray.com/wp-admin/ it takes me to my old cruitme instance

DezUk · 28 Mar 2015 at 19:27

Ok cool got the plugin working now so what should I enter as old url and new url?

old: cruitme.com/projects/nelson
new: nelsongray.com

?

DezUk · 28 Mar 2015 at 19:48

All fixed, much appreciated mate!

DezUk · 28 Mar 2015 at 20:04

Well spotted!

I ran the GoLive plugin and it sorted most of the links, how do I sort the images without having to do it manually?

DezUk · 29 Mar 2015 at 17:08

Black Dynamite said:
Download the stable version of this -> https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

Upload it to your web server and extract it.

Navigate to this folder in your browser. from there just enter www.original-address.com in the replace field and www.new-address.com in the with field.

Click live run and then check your links. If its worked delete the utility.

That should be it mate, if you get stuck, let me know

Running this sorted it out, thanks a lot mate

DezUk · 31 Mar 2015 at 23:30

dmsims said:
and this why you use the Duplicator plugin

Tried the Duplicator plugin and didn't work for me, glad I did it manually as I learnt something and was good to get stuck in