|

WordPress Blog Transfer – New Host

Transferring your WordPress blog to a new host can be the most stressful experience a blogger may have to endure.

You see many bloggers & would be web entrepreneurs are fairly new to the workings & intricacies of WordPress & also MySql Databases, therefore they often find themselves stepping into deep water as it were, beads of sweat appear on the brow, the heart rate starts climbing, all sorts of terrifying thoughts race through your mind … “Argh What If…??? ”

Panic not my friend, I am going to give you a detailed method of switching your hosting company without losing all your valuable articles, photos & videos and best of all I will do it in plain English & with screenshots where necessary.

This guide is going to use CPanel which is the most popular host management system, however there are a few other systems also in use  which may differ slightly to the details below. If you do use a different host management system then you should find the basics are still more or less the same & if you just read carefully then you should have no problem applying this guide to your own system.

Before we start, lets just understand one very important fact and that is quite simply that without a functioning database, WordPress is just a bunch of useless files! That being the case you should realise that your database is of the utmost importance & should always be guarded against mishaps! So before we go any further, we are going to take a manual backup of your database.

It is a good idea to create 2 folders on your desktop “Old Files” & “New Files”, these are for use in transferring your blog & changing your domain name, (We will deal with changing domain names in a follow up article).

Step 1 Backup Your Database

Once Logged in to CPanel, scroll down the page until you find databases (usually 2/3rds down the page). The icon we need to click on is “PhpMyAdmin”, this is the admin control panel for your databases.

WordPress Blog Transfer – New Host

1.1 Click on the icon “phpmyadmin”

 

WordPress Blog Transfer – New Host

 

1.2 Now select your database from the list on the left.

Note: The red stars indicate your username & all of your databases will be listed below, the typical or default database when using WordPress is _wrdp1

 

WordPress Blog Transfer – New Host

 

1.3 After selecting your database you will see the above screen, click on the “Export” tab.

 

WordPress Blog Transfer – New Host

 

 1.4 This screen shows the default settings and the numbered steps to export a copy of your database.

1.4.1 Select All

1.4.2 Check “Save as File”

1.4.3 Choose gzipped & check box “remember template”

1.4.4 Click “Go”

WordPress Blog Transfer – New Host

1.5 Again the red stars indicate your username – Now simply browse to the folder “Old Files” which you created earlier & then click “Save”

You now have a gzipped backup of your database safely stored in the “Old Files” folder on your desktop.

Note: As an added precaution I always like to go back to step 4.3 above & save a 2nd copy of my database, but this time choosing “No Compression” (This is purely optional)

Step 2 Backup Your WordPress Core Files

2.1 Using you favorite FTP Software, now take a complete backup of your public_html folder, this is the root folder on your current hosting account & is where all your WordPress files, images, themes & plugins are stored. Save this backup into your “Old Files” folder on your desktop.

Note: There are different methods available to take backups of your root directory, I just find FTP a less problematic method, but you can achieve the same thing using CPanel’s File Manager or Backup Wizard.

Now that we have complete backups of both your database & your WordPress files, it is now safe to proceed with a transfer to a new host. If you are moving WordPress to another hosting service & also changing your domain name, then this will be dealt with in a follow up article as it is a little more involved.

Step 3 Transfer To A New Host / Server

3.1 Now log in to your new CPanel with your new hosting company, this can be a little tricky as your old hosts CPanel is still active. The easiest way to ensure you log in to the correct CPanel is to browse to http://**.**.**.**/cpanel the stars indicate your new hosts / servers IP address, which will have been notified to you via email when you signed up & then login with your username & password.

Creating A New WordPress Database

3.2 There are a couple of methods to do this, but by far the easiest is to use Fantastico to install a fresh WordPress blog. Once logged into your new CPanel, scroll down until you find Software /Services as shown below;

WordPress Blog Transfer – New Host

Click where indicated to access Fantastico.

3.3 When Fantastico opens you will see the image below, simply select WordPress from the left hand menu.

WordPress Blog Transfer – New Host

Select new installation as indicated above

3.4 Now fill in your details as indicated below, hopefully keeping them the same as on your old hosting account. If it has not been possible to keep the username , database name & password the same, then you will need to edit your config.php file to reflect the new details. (We will deal with this later)

WordPress Blog Transfer – New Host

Click where indicated to install WordPress.

3.5 If all has gone according to plan you should see the screen below, simply click where indicated to finish installation.

WordPress Blog Transfer – New Host

3.6 You should now have the confirmation screen below, which gives you all the details of your new WordPress installation.

WordPress Blog Transfer – New Host

Click as indicated above to return to WordPress overview & then log out of CPanel.

Step 4 Upload WordPress To New Host

4.1 The next step is to use your favorite FTP software to upload your backed up copy of your original WordPress blog & overwrite the new files which have just been created. This does not include your database, this is only your core files in /public_html (your root directory). Quite often & as long as the versions of WordPress are the same, I will only upload the /contents/ directory as this is where all images, plugins & themes etc are stored. Whilst using your FTP client it is also a good time to double check the details of your config.php file, make sure the username, database & password are correct , edit where necessary.

4.2 Ok now it is time to overwrite the new database that you created earlier, so log back into your new hosts CPanel & once logged in browse to phpMyAdmin.

WordPress Blog Transfer – New HostClick on the icon highlighted

4.3 Now select your database as shown in the image below;

WordPress Blog Transfer – New Host

Note: Red Stars Indicate Your User Name

 WordPress Blog Transfer – New Host

 

4.4 After selecting your database follow the steps indicated in the image above

4.4.1 Select check all

4.4.2 Click on the arrow indicated to open the menu

4.4.3 Select Drop

WordPress Blog Transfer – New Host

4.5 You will now see the confirmation screen above, click yes as indicated

WordPress Blog Transfer – New Host

4.6 You will now see the confirmation screen above which indicates a successful drop of all tables. Then click on your database as indicated to refresh the page.

WordPress Blog Transfer – New Host

4.7 Select Import as indicated above

WordPress Blog Transfer – New Host

4.8 Follow the 2 steps indicated above

4.8.1 Click on the browse button to browse to your original saved database & select it for import.

4.8.2 Once selected click the Go button as indicated above.

4.9 You have now successfully imported your original database & providing all has gone to plan, you will see the confirmation screen below.

Note: An easy way to check that you have selected the correct database is to compare the number of tables. A new install of WordPress only has 10 tables (those are the tables you dropped earlier). As can be seen in the image below this database now has 19 tables (the number is indicated in brackets)

WordPress Blog Transfer – New Host

Step 5 Change Your Nameservers

The final step in this process is to go to the registrar of your domain name (not necessarily your old host) & change your Nameservers to point to your new hosting account. The details required for this will have been notified to you by your new host. Once this step is completed it will usually take anything from 4 to 24hrs for the new details to propagate around the web. Until such time, your old hosting account will still be functioning and will continue to serve your web pages as usual.

WordPress Blog Transfer – New Host

Note: It can be a little tricky knowing which host is actually serving your web pages, I simply upload a basic index.html file (as shown above), to my new host. Once I see this file when browsing to my website, I know that the new hosting account is actually up & running and has propagated the web. Then it is simply a matter of using your FTP program to access your account and delete this html file. You should then fully check that everything is functioning correctly before proceeding to delete the files & database on your old hosting account.

Phew!! a long drawn out process I know, but such detail is necessary in order to prevent any mishaps.

It is perfectly natural to feel anxious when carrying out such a detailed task as switching a hosting account, but believe me it does get easier the more times you do it hahaha. If any of you feel that this is a little more technical than you are comfortable dealing with, then My Blog Review does offer a transfer service for a nominal fee. If you would like us to deal with a transfer for you then simply contact me using the following link Contact Us


No related posts.

Posted by on Mar 1 2010. Filed under Create A Blog. You can follow any responses to this entry through the RSS 2.0. You can leave a response or trackback to this entry

8 Comments for “WordPress Blog Transfer – New Host”

  1. Yes that was why I asked, because very often you cannot keep the exact same DB name, because if that prefix. I have had some hosts where I had to include wrdp1_?? but then others where it would only accept ?? and unfortunately I have never been able to find out which they accept prior to a move.

    Best I can suggest is if you use “admin” as user, then try changing it to “wrdp1_admin”
    Ah you sorted it , ok that’s great !

  2. I seemed to have fixed it my self…. which is a minor miracle.

    I went into the SQL DB and changed the wp_options table on line 1 and 39 to the new address, and it updated all my permalinks and internal site links.

    woop woop

    thanks for your help Steve!

  3. H Steve,

    I had some help from the support people at MediaTemple – which was unexpected, as strictly speaking, the WP install isn’t really their responsibility – but they managed to change the config file so that the content was infact showing at the new host (they said it was a U/P issue)

    - BUT –

    when I go to login at the new address /wp-login.php it logs me in and takes me to the old site… which obviously doesn’t help.

    I wasn’t able to setup the new DB with the same name as MediaTemple has a *set* prefix they add to the new DB’s – so that made things more difficult I guess.

    If you have any ideas about what might be causing that mis-directed login that would be great – Not sure how much I can expect the support people to keep helping me out at (mt)

    Thanks mate! – C

  4. Hi Corey,

    sorry for the delay in getting back to you, but being in the Philippines we get subjected to some rather lengthy power cuts at times!

    Right now I’m not sure what the exact problem is here, so I need some info from you first.
    Are you keeping the same domain name..?

    If so then I it sounds like the problem could be the security key you have set in your config file, (the jumbled text you metioned) if you cannot remember what you entered in your security key then I suggest you delete it completely (it’s usually on 3 lines) & then try again. If you have moved to a new host, then did you setup a database with the exact same name…? This is very often the cause of problems

  5. Mmmmm…. So no joy as yet.
    I figure there must be a problem with the DB name… which I assume should be the new DB name – as we drop the tables and imported the old DB in… which all worked fine.

    The username and password I’ve set as per the old DB.
    The DB_host I’ve set as per the new host.

    BUT…. all I’m getting here is ‘ERROR ESTABLISHING A DATABASE CONNECTION’

    The usernames and passwords in my other WP installs on the same server don’t appear to be as they are – ie their all jumbled – I assume some kind of code algorithm or something… so not sure if that’s right either. Bit lost I’m afraid Steve….

    I’ve had a look through the SQL data, and everything is in there no troubles… so thats re-assuring. I just can’t seem to tell my WP install where the database is!! :)

    Any clues here?

  6. Hi Steve, Thanks so much for the info. I’m in the middle of my ‘cross-over’ now – but I’ve not found anywhere online that has provided such a good step by step guide.

    One question… with the config file…
    I assume I am changing the config file on the fresh install so that it matches the details embedded in the SQL from the old server right?

    I’ll have a play when the upload is finished – but just checking…

    Thanks again Steve – saved me some stress for sure. (fingers crossed ;) )

    Corey

  7. Hello Honey,

    Ideally you should upgrade before taking a backup & then you know for sure that everything is the same when you install the latest version.
    However as I stated in the article what you are doing is a method I often use myself as a short cut.
    Remeber to double check the details of you config.php file ???
    Hope all goes well – Steve
    .-= Steve´s last blog ..Hexbug =-.

  8. hello. i’m in the process of transferring my blog to a new host. i followed your instructions except for step 2. i only backed up my wp-content folder. will it be ok? coz i’m installing the latest version of wordpress on my new host ayway. then i’ll just put the old wp-content folder and remove the new one. thanks.

Leave a Reply

*


Advertise Here:

More From This Category

Sponsored Ads

Business WordPress Themes Scribe. SEO Made Simple.
Catalyst Theme - WordPress Accelerated
How smart is your Theme?  How good is your support? Check out ThesisTheme for WordPress.
No Need For WordPress Developers — Drag & Drop With Headway link building
Sell Your Website - WebsiteBroker.com
QuickHits - 1000's of website visitors every month - Guaranteed