Vista combinada Visión Plana Vista de árbol
Discusiones [ Anterior | Siguiente ]
toggle
Peter B West
Anyone upgraded MySql from 5.1 to 5.5 in 6.0.6?
26 de octubre de 2011 19:23
Respuesta

Peter B West

Ranking: Junior Member

Mensajes: 57

Fecha de incorporación: 23 de marzo de 2009

Mensajes recientes

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?
27 de octubre de 2011 5:52
Respuesta

Hitoshi Ozawa

Ranking: Liferay Legend

Mensajes: 7952

Fecha de incorporación: 23 de marzo de 2010

Mensajes recientes

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?
27 de octubre de 2011 9:30
Respuesta

Peter B West

Ranking: Junior Member

Mensajes: 57

Fecha de incorporación: 23 de marzo de 2009

Mensajes recientes

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?
27 de octubre de 2011 14:54
Respuesta

Hitoshi Ozawa

Ranking: Liferay Legend

Mensajes: 7952

Fecha de incorporación: 23 de marzo de 2010

Mensajes recientes

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?
22 de noviembre de 2011 18:56
Respuesta

Peter B West

Ranking: Junior Member

Mensajes: 57

Fecha de incorporación: 23 de marzo de 2009

Mensajes recientes

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?
23 de noviembre de 2011 4:35
Respuesta

Hitoshi Ozawa

Ranking: Liferay Legend

Mensajes: 7952

Fecha de incorporación: 23 de marzo de 2010

Mensajes recientes

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?
9 de mayo de 2012 6:12
Respuesta

Peter B West

Ranking: Junior Member

Mensajes: 57

Fecha de incorporación: 23 de marzo de 2009

Mensajes recientes

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?
9 de mayo de 2012 6:21
Respuesta

Hitoshi Ozawa

Ranking: Liferay Legend

Mensajes: 7952

Fecha de incorporación: 23 de marzo de 2010

Mensajes recientes

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