Re: Migration path
There's a recommended way to do the upgrade, but it's not easy peasy.
The main thing to take into account is that you should upgrade from consecutive major versions, for only upgrades between consecutive major versions are supported and guaranteed to work. This means upgrading from 4.1 to 5.5 should take the sequence 4.1 -> 5.0 -> 5.1 -> 5.5 to upgrade. Although skipping versions should work, it is not guaranteed. After each upgrade step, make sure you run the 'mysql_upgrade' program to get all the table versions and system tables updated and ready to run.
Remember to always backup your database and to try first in a development server (not in a real production server).
Always read the manual page regarding the upgrade process for the server version you are upgrading to (i.e.
http://dev.mysql.com/doc/refman/5.5/en/upgrading.html for MySQL 5.5).
Hope this helps.
Sergio A. de la Cruz RodrÃguez
Software Developer
Oracle Corp.
Subject
Written By
Posted
Re: Migration path
April 18, 2012 02:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.