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.
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: http://lists.mysql.com/mysql?unsub=1