List:General Discussion« Previous MessageNext Message »
From:Wm Mussatto Date:March 9 2009 8:20pm
Subject:Re: Upgrading
View as plain text  
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.

> 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:
>> To unsubscribe:

UpgradingMatthew Stuart9 Mar
  • Re: UpgradingAndy Shellam9 Mar
  • Re: UpgradingMihail Manolov9 Mar
    • Re: UpgradingWm Mussatto9 Mar