Re: Migration path
Posted by: Sergio de la Cruz
Date: April 18, 2012 02:14PM

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.

Options: ReplyQuote


Subject
Written By
Posted
April 18, 2012 01:53AM
Re: Migration path
April 18, 2012 02:14PM
April 19, 2012 03:58AM
April 19, 2012 06:37AM
April 20, 2012 09:30AM
April 22, 2012 02:19PM


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.