Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Peter B West
Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
October 26, 2011 7:23 PM
Answer

Peter B West

Rank: Junior Member

Posts: 57

Join Date: March 23, 2009

Recent Posts

I'm running 6.0.6 tomcat 6.0.29 with MySql 5.1. Has anyone tried to upgrade their MySql installation to 5.5? I experimented with this a while back, and the portal refused to come up in my tests, so I left it alone.
Hitoshi Ozawa
RE: Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
October 27, 2011 5:52 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

I'm using MySQL 5.5 in production without any problem. I've just used 5.5 from the start and didn't version up.
What problem did you have with the upgrade?
Peter B West
RE: Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
October 27, 2011 9:30 AM
Answer

Peter B West

Rank: Junior Member

Posts: 57

Join Date: March 23, 2009

Recent Posts

I don't remember the details, but the instance was fairly badly screwed up. Rather than try to track it down, I just backed off and left the production instance alone. It may have been a trivial incompatibility, but it made the instance unusable.
Hitoshi Ozawa
RE: Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
October 27, 2011 2:54 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Just out of curiosity, how did you upgrade your MySQL? Did you use export/import?
Peter B West
RE: Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
November 22, 2011 6:56 PM
Answer

Peter B West

Rank: Junior Member

Posts: 57

Join Date: March 23, 2009

Recent Posts

Sorry about the delay in getting back.

Frankly, I can't remember the details. I think I did export/import, but I can't swear to it. Thanks for the feedback.
Hitoshi Ozawa
RE: Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
November 23, 2011 4:35 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Thanks. Didn't have any problem upgrading default mysql that comes by default in CentOS 5.x to 5.5.
May have been engine difference.
Peter B West
RE: Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
May 9, 2012 6:12 AM
Answer

Peter B West

Rank: Junior Member

Posts: 57

Join Date: March 23, 2009

Recent Posts

To tidy this one up:

I have been able to upgrade without (Liferay) problems, and without export/import, by following the recommended procedure for MySQL, while Liferay was shut down.

The process is described in the MySQL documentation for 5.5.

I'm running OS X Lion as my development machine, with the live server on a Unbuntu 10.4 VM. The problem that I did have was that the OS X install process for 5.5 left an incompatible variable value in the /etc/my.cnf file. This was causing a failure of MySQl. Once I tracked that down, and made sure it was not causing problems on either system.

The 5.5 value is skip-external-locking. From memory, the earlier, incompatible value is skip-locking.

Peter
Hitoshi Ozawa
RE: Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
May 9, 2012 6:21 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

Yes, I just did a upgrade from MySQL 5.1 to 5.6 and didn't encounter any problem too. :-)