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!
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.
>> 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.
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: