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.
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 ;-)