Restoring WordPress

Moving across from legacy SupaNames account to 123reg and issues with permalinks

Supanames was taken over by 123-reg a few years ago.  This wasn’t something that affected me initially and I continued to use my Supanames account as always. However when recently trying to install the latest version of WordPress I found that the version of MySQL was not compatible with the latest upgrade.  I contacted 123-reg who informed me that there was no plan to upgrade old Supanames hosting and so with great reluctance I began to make preparations to move over to the more up to date 123-reg hosting.


The first thing to do was to backup the database.  This is remarkably simple to do using the Supanames MyPanel interface.

  1. Go to MyPanel and then in the Left-hand menu choose MySQL DATABASESMySQL Backup Submenu.
  2. Click on the link on the next page in MyPanel to Backup your Database.

 

If successful, you will receive a message confirming the backup has been completed. The backup is zipped and stored on the root directory of your web space. Having done this I then downloaded my entire site via FTP (I use Filezilla) including the zipped database backup.

I am fortunate that I don’t have hundreds of email boxes consider, all mine are hooked into gmail accounts and I have records of the alternate addresses. So I contacted the account holders to inform them that their mail would be down for maintenance.  Once this was done I gave 123-reg the go-ahead to close down my old Supanames hosting and fire up the new one.  This was ready to go in a couple of hours and the first thing I did was re-establish the mail boxes and send instructions to the users on how to reconnect.

Next I FTP’d the entire site back up to the root directory so that it had exactly the same structure as it did before.

The final step is to restore the database and modify the configuration so pages and database can talk to one another.  Restoring a database with 123-reg is not quite as simple as Supanames but it is no great technical feat either.  First you need to create a database. In your 123-reg control panel go to Web Hosting -> Manage

Manage Web Hosting

Then select Manage Database -> Add database

Add Database

Take a note of the username, password and server, you will need these for the config file. Return to the Add database screen and log on to your new database. Select the Import tab:

Import SQL

Select the previously downloaded backup via Choose File and then hit the Go button (you should be able to leave all other settings at default).  Hey presto your database is restored. Now for the configuration.

wp-config.phpYou need to edit your wp-config.php file typically found in the root directory of your web space.  Enter the database name, user and password against DB_NAME, DB_USER, DB_PASSWORD respectively (you can get the database name from the Add Database screen). On the old Supanames hosting the host name (DB_HOST) was set to ‘localhost’ this now needs to be set to the server name.  Once done save wp-config.php back to your web space.

After doing this I was pleased to see my front page (this blogg) functioning correctly, however when I selected any of the links I was given a 404 Not Found error.  A quick Google and my suspicions were confirmed, it was something to do with the permalink structure I was using. I found a number of solutions and didn’t like any of them much so before trying any of them I went into my WordPress  Admin and selected Settings -> Permalinks.  I did not change any of the settings, merely selected the Save Changes button.  This completely fixed my problem, so I urge you to try this before one of the more complex and possibly dangerous solutions on the net.


6 thoughts on “Restoring WordPress

  1. LOL, yes, funnily enough they didn’t get back to me on that one Lee. Although now thinking of leaving them altogether as hosting is proving to be slow and unreliable, so watch this space 😉

  2. Hi RedEyedMonster

    The reason for Andy’s reply is that the plan’s to migrate accounts were in the early stages at that time.

    We do expect to have migrated all Supanames account to similar specifications to those offered on 123-reg by the end of the year.

    Regards,

    Ricky

  3. Hi

    I work on behalf of 123-reg.

    We do plan to upgrade all Supanames packages to 123-reg packages before the end of this year, which means Supanames customers will be able to use new versions of PHP and MySQL needed for WordPress and other CMS based sites.

    Sorry that this could not be done in time for your web site, however I would like to thank you for taking the time to write this helpful guide.

    Regards,

    Ricky

    • That’s not what Andy said:

      Dear Nigel,

      Thank you for contacting 123-reg on the 04th July 2011.

      As a Supanames customer you have legacy hosting that is no longer in development, so the MySQL version will not be updated on this platform.

      Should you wish to have hosting with MySQL5 our customer relationship team can remove your Supanames hosting.

      This will allow you to purchase new 123-Reg hosting which does include MySQL5:

      http://www.123-reg.co.uk/web-hosting/comparisonpage.shtml

      Please contact our Customer Relationship team on 0845 859 0023, quoting this ticket number. Our Customer Relationship team are available Monday – Friday 9am – 5.30pm.

      Our Customer Relationship Team will be able to discuss your requirements and assess which of our packages will best suit your needs. They can then order the package for you and arrange closure of your current package at a date that suits you.

      If we can be of any further help with regard to this or any other matter, please do not hesitate to contact us.

      Kind Regards

      Andy
      123-reg

Leave a reply ...