From: Wm Mussatto
Date: March 9 2009 8:20pm
Subject: Re: Upgrading
List-Archive: http://lists.mysql.com/mysql/216643
Message-Id: <3705.67.101.48.202.1236630035.squirrel@secure2.csz.com>
MIME-Version: 1.0
Content-Type: text/plain;charset=UTF-8
Content-Transfer-Encoding: 8bit

On Mon, March 9, 2009 12:51, Mihail Manolov wrote:
> I would strongly suggest logging all your 4.0 queries for at least 24
> hours and then running them on your new 5.x server to avoid any
> surprises such as incompatible queries for example.
>
> Good luck!
>
> Mihail
Good idea.  I would pay particular attention to LEFT JOINs.  MySQL began
more strictly following the SQL specs and that caused me problems when I
did the upgrade.

Bill
> On Mar 9, 2009, at 1:42 PM, Matthew Stuart wrote:
>
>> Hi all, I am on... wait for it... version 4.0.25 and I want to
>> upgrade to MySQL 5.x
>>
>> Is there anything special I should do in order to upgrade? Do I need
>> to uninstall v4 or can I just download the most current version and
>> double click to upgrade? I am not particularly hardcore mysql
>> minded, and quite honestly, if it ain't broke don't fix it is a good
>> mantra of mine... but I need to move on now as I have received an
>> sql file that is v5 compatible but not v4 compatible.
>>
> mysql@stripped
>>
>> Once I have it up and running I'll be fine, it's just that I am
>> nervous about upgrading and consequently breaking it, and at that
>> point, I'll be struggling to put it right.
>>
>> Any advice on how I can best do this / best practices etc will be
>> very much appreciated.
>>
>> Many thanks.
>>
>> Mat
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=mmanolov@stripped
>>
>
>