WordPress Update requires upgrading to PHP 5.x and MySQL 5.x

Writing by on Wednesday, 27 of July , 2011 at 9:19 pm

After upgrading to WordPress to 3.2 all hell broke lose! I wasn’t able to even see the blog …

Your server is running PHP version 4.4.9 but WordPress 3.2 requires at least 5.2.4.

So I went ahead called my hosting provider and upgraded PHP and was able to see the blog but couldn’t add/update new posts…

You cannot update because WordPress 3.2 requires MySQL version 5.0 or higher.

Don’t Panic (These 5 steps worked for me and will probably get you past your little hurdle).

  1. Backup your database (This is probably a MySQL 4.x database)
    1. If you don’t know which database then
    2. Open up Path_To_WP_Blog/wp-config.php
      1. define(‘DB_NAME’, ‘jb007’); // The name of the database
      2. define(‘DB_USER’, ‘jb007’); // Your MySQL username
  2. Create a new MySQL 5.0 database
    1. Note down credentials (Your hosting provider should have a way to get this for you)
      1. $hostname
      2. $dbname
      3. $username
      4. $password
  3. Restore the Backed up 4.x database on the new 5.x database
    1. Your hosting provider should have a way to get this for you
  4. Update the wp-config.php
    1. From the credentials you noted down in Step 2
  5. When you login to your admin, WordPress may require a further update which is a painless click of a button and then you should be good to go!

Leave a comment

Category: Hosting/Web,Wordpress

No Comments

No comments yet.

Leave a comment

You must be logged in to post a comment.

Shivdev Kalambi's Blog

Shivdev Kalambi is a Software Development Manager, previously a Principal Software Engineer at ArcSight/HP. With over 16 years' experience in software development, he's worked on several technologies and played different roles and contributed to all phases of projects. Non-tech activies include Ping-pong, Rock Climbing and Yoga at PG, Golf, Skiing, Swimming & a beer enthusiast.