WordPress 3.2 is here!

On July 4?? WordPress released version 3.2 which requires PHP version 5.2.4 or greater and MySQL version 5 or greater.

(Click Image to enlarge)

If you’ve been using WordPress since version 2.9 your database may be located on our MySQL Version 4 servers, if this is the case you will see the following error message when trying to update WordPress.


(Click image to enlarge)

If you haven’t received this message then you may proceed with your WordPress update remembering to back up your WordPress files. You can find a guide on how to backup your files via FTP by Clicking Here.

If you received this message then you will need to move your database to our MySQL 5 Server. There is already a MySQL 5 server available on our cluster, if you wish to move to this you will need to create a new database then migrate your database across to the new server.

To begin you will need to login to your Online Control Panel, this can be found on our homepage or by visiting http://admin.names.co.uk

– Once you have logged in select “Domain Names” on the left menu.

– In the middle of the screen there will be a list of your domains, please click on your domain name.

– Going back on the left menu, select the option “MySQL Databases”

– In the middle of the screen you can click on “Add Database” to create a new database and select our MySQL 5 Server, which can be seen below.

(Click Image to enlarge)

Now that you’ve created a new database you will now be able to migrate your old database via PhpMyAdmin. You can access the login page by visiting http://www.mydbadmin.co.uk/

You will need to enter your old database username, password and select the server your database is on in the drop down menu to login.

Once you have logged in you will need to export the database to your local computer, simply select the export option as shown below.

(Click image to enlarge)

You will then be presented the export options page, on this page the default options are normally OK but you will need to ensure “Save as file” is selected as this will allow you to download the database files to your computer. Once done, select “Go”.

(Click image to enlarge)

We will now need to import your old database into your new database again this is done via PhpMyAdmin. Firstly you will need to log out of your current database by clicking the green exit button on the left menu.

You will now be presented with the database login page again, this time you will need to enter your new database details which you created in the steps earlier and select MySQL Server 5 in the server drop down menu.

Once you have logged in you will need to import the database to by selecting import as shown below.

(Click image to enlarge)

You will now be presented with the import options where you will be able to select your database file from your local computer. Simply select “Choose File” then select the database. Once you have selected your database file on your local computer select “Go”

PhpMyAdmin will now import your database for you, there maybe a slight delay while this importing your database.

(Click image to enlarge)

After your database has been imported you will then need to update your wp-config.php file so WordPress connects to your new database. WordPress have created a guide on how to edit this, you can find this by Clicking Here

When editing your wp-config your Database Host address will be mysql5.namesco.net

You can delete your old database via your Online Control Panel – http://admin.names.co.uk

– Once you have logged in select “Domain Names” on the left menu.

– In the middle of the screen there will be a list of your domains, please click on your domain name.

– Going back on the left menu, select the option “MySQL Databases”

You will then have a list of your databases, select the database you wish to remove, then select “delete” as shown below.

(Click image to enlarge)

If you have any questions you can submit an enquiry to our support team via your Online Control Panel – http://admin.names.co.uk

– Login to your Online Control Panel and click on “Support Tracking” then “New Support Enquiry”

– Fill out the form on-screen, detailing your request

– Select the right team to deal with your enquiry from the drop-down menu- Finally, click on “Submit”

 

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks

7 thoughts on “WordPress 3.2 is here!

  1. Hi, I’ve just tried this on my account and this method will/does not work.

    Attempting to import the old database to the new one you receive the message

    Error
    SQL query:


    — Database: `1stdatabasename`

    CREATE DATABASE `1stdatabasename` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

    MySQL said:

    #1044 – Access denied for user ‘username’@’ipaddress’ to database ‘1stdatabasename’

    -resolved now-

  2. Okay, with some manual editing to the downloaded database I’ve managed to get it to import.

    However I still can’t update WP as the PHP version is still showing as; MySQL client version: 4.1.22 on the mysql5 database?

  3. Hi, I see you’ve edited and removed one of my posts. Well yes, I did fix things and get them to work, only took a couple of hours to work out, however following these instructions the next person will have the same issue as I did – these instructions do not work with PhpMyAdmin and wordpress – the database will not import, try it and see.

    1. Hello Chris,

      I have tested multiple databases a number of times and it works with a databases I’ve been using with WordPress for about 6 months.

      Databases can vary with WordPress as it can have custom tables for plugins, themes etc which can effect the importing of the tables into a new database. If you experience any other problems you can contact our support team by submitting an enquiry via your Online Control Panel – http://admin.names.co.uk

      1. Hi Kyle, thanks for your reply, luckily I worked out how to get it to work whilst waiting for a support reply, then found I also needed support to upgrade my php version.

        The problem is that PhpMyAdmin won’t import an exported database directly without you manually editing out some of the header info of the exported database. Or at least out of the 4 times I’ve had to do this on namesco hosted accounts its been the case each and every time, its not so much to do with wordpress as how PhpMyAdmin works. But I know how to do it now so its not a problem, I just thought it might be helpfull to let other people know as I imagine I won’t be the only person with this issue.

        Thank you.

  4. Hi,

    I’m having the same problem with mysql database upload as Chris had (#1044 – Access denied for user …)

    I did have a mysql database, however I needed to download it but in the process accidentally deleted it. How can I re upload this to my server?

    I see that a post may have been deleted that could help with this. I have searched everywhere but having difficulty finding the solution. Especially at Namesco!

    PLEASE help

    – C

    1. Hello Calum, it would be best to raise an enquiry via your Online Control Panel so our support team can investigate this for you.

Leave a Reply

Your email address will not be published. Required fields are marked *