Saturday, March 29, 2008

MySQL 3x to MySQL 5

Last week I was tried to migrate a database server which was running on MySQL 3x to a lampp platform with MySQL 5x. I faced an interesting problem.

In MySQL 3x index, option... can be used as field names, but not in MySQL 5x. Beucase when I do mysqldump and try to restore it into MySQL 5x, it gave errors... And those errors were pointed to those error fields

Mostly Joomla and Mambo databases give this problem.

Solutions :
1. When we do the mysqldump we can add '`' to the field names (plz go through the mysqldump manual)
2. We can manually search for this kind of errorness field names and put '`' around it :-)

I was under the impression that the new version always supports for the older version. But that is not always true ;-)

Monday, March 24, 2008

ta-LK language pack for Joomla 1.5.2

Joomla! has added ta-LK (Sri Lankan Tamil) support to Joomla 1.5.2. Currently the installation packs are available and very soon the site and admin language packs will be available in the Joomla! org site... I am very happy to say that I also involved in this language pack preparation work :-)