How to change SQL versions.

  • HI

    My host is finally changing from SQL 4.1 to SQL 5.
    How do I handle this change?

    Kind regards Jgaard

Viewing 14 replies - 1 through 14 (of 14 total)

  • Can you post your site URL?

    Thread Starter jgaard

    (@jgaard)

    https://geocaching.thusgaard.eu/

    Your host is already running PHP 5.2.17. But you are running an old version of WordPress. It is better to upgrade your WordPress version to the latest version. There is nothing else you need to do.

    Thread Starter jgaard

    (@jgaard)

    Well PHP is one thing SQL is another.
    The PHP I can handle but how do I handle the change of SQL DB?

    Login to your hosting account. You can find the MySQL there and its version. Most probably, as every other host does, your company also will be using the compatible version.

    Thread Starter jgaard

    (@jgaard)

    My problem is that my host is changing from SQL 4.1 to SQL 5.

    Everything is working today but I’m guessing it wont be when they do the update!

    The site is locked down as it’s a private info site for geocaching friends.

    As technology gets updated everything depending on it follows suit. That is what your host is doing, and WordPress also gets updated. So, you too have to upgrade your WordPress version.

    Thread Starter jgaard

    (@jgaard)

    I’m aware. I’m just looking for advice on what to do to secure the pending SQL opgrade.

    Is there a WP version that handles both SQL versions so I can make the move to a new SQL version. The current newest WP does not support my current SQL version.

    So I don’t need PHP info or advice on what to do as technology progresses. I need advice on what to do to get this SQL update. with out loosing my site! having to redo my site or restoring from backup!

    Please contact your host for the above question.

    Thread Starter jgaard

    (@jgaard)

    it’s a wordpress related question.

    My host is going to change to SQL 5.1 on 31th of august.

    Which WP version will give me the smoothest change to new SQL DB?

    That is not a question for my host!

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    Which WP version will give me the smoothest change to new SQL DB?

    *Reads* Wait. What? No, I’m afraid it really isn’t a WordPress problem and this is a question for your host.

    WordPress 3.4.1 requires a minimum MySQL 5.0 or higher. You are running WordPress 3.1 on (apparently) MySQL 4.1.

    If you will not find a new host (that’s your decision) then remain at the (old, un-patched, with security issues, please find a new host real soon now) version that you are running now.

    After your host makes MySQL 5.1 available on then backup your files and database and ask your host to switch you to the more current version of MySQL.

    That’s all.

    Thread Starter jgaard

    (@jgaard)

    Hmmm according to my host I just need to make sure that my web applications are ready for SQL 5. They will move data to the new DB.

    And if that is the case I just need to make sure that my WP is at the latest version before the swap. How ever the current WP version dosn’t support SQL 4 so I cant upgrade to that version.

    translated version of my hosts mail about the change:

    Time has run mySQL 4 and it has therefore become necessary to phase out support for MySQL 4 completely from Surf Town. Many of the larger and popular CMS and software providers (eg WordPress) has already long since removed support for mySQL 4 in their latest versions. Therefore we are unable to update parts of our software on the servers, such as phpMyAdmin, so long as the servers using an older version of mySQL.

There are also other benefits of upgrading to MySQL fifth Is your application / website, for example, coded to be compatible with and utilize the features in MySQL 5, so many will also experience a faster database with greater security.

Important: Lack of backwards compatibility
When the upgrade is a risk that compatibility problems with any applications you use, or the code you have developed. It is therefore important that you ensure that your code is compatible with MySQL 5 by 30 august, 2012.

The most popular applications are already compatible with MySQL 5, so you should just make sure that the latest versions of your applications are installed. You can usually upgrade to latest version via the application's administration module or download latest version from the publisher's website. There are also often documentation on how to upgrade.
    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    And if that is the case I just need to make sure that my WP is at the latest version before the swap.

    Noo, don’t do that. If you put the current version on top of your existing version first, then you will not be able to run or admin your WordPress.

    Leave your version as is for now and make a full file and database backup.

    https://codex.www.ads-software.com/WordPress_Backups
    https://codex.www.ads-software.com/Backing_Up_Your_Database
    https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup

    Your host should provide you a time to select the version you are using. When that happens, deactivate all of your plugins and switch to the Twenty Eleven theme.

    Then make the migration from MySQL 4.1 to 5.x. Everything should just work and if it does then upgrade to the latest version of WordPress.

    Once you’ve upgraded then re-activate your plugins and switch back to your theme.

    If at any step something Really Bad Happens™ (it shouldn’t) then put back MySQL 4 and restore your files and database as it was prior to the migration to MySQL 5. And seek help after that. ??

    Thread Starter jgaard

    (@jgaard)

    That was what I was looking for Thank you very much

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘How to change SQL versions.’ is closed to new replies.