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@lists.mysql.com >> >> 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=mmano...@liquidation.com >> > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
