Forum LAMS for Tech-Heads - General Forum: Dose lams2.3.4 support mysql5.5？

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Leo,

No, I haven't been able to try mysql 5.5. But what are the errors that you are getting?

Thanks,

Ernie

Posted by Ernie Ghiglione

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Leo,

I've just tested MySQL 5.5 and LAMS using the the Windows installer and it all worked well.

So, when you have a chance send me the error messages you are getting.

Thanks

Ernie

Posted by Ernie Ghiglione

By: leo luo

[ Reply | Forward ]

I had found the solution by my problem. In my case, I always building lams from source,not any installer. and I found the 'TYPE=InnoDB' sql script error when I run rebuild-db ant targert , so I change the sql to 'ENGINE=InnoDB' anywhere in lams sql script.And it can build well now. I guess the problem is 'TYPE' keyword doesn't work in mysql5.5.


Thanks for your help Ernie

Posted by leo luo

By: Ernie Ghiglione

[ Reply | Forward ]

Thanks Leo.

I've just setting up a LAMS server (building it from source) using MySQl 5.5 and I came across this same problem.

Here are some command you can run in your shell (unix) to change these in all the LAMS code:

find . -name *.sql -print0| xargs -0 sed -i 's/TYPE=InnoDB/ENGINE=InnoDB/g'
find . -name *.sql -print0| xargs -0 sed -i 's/type=innodb/ENGINE=InnoDB/g'
find . -name *.sql -print0| xargs -0 sed -i 's/TYPE=innodb/ENGINE=InnoDB/g'

These would change all your TYPE=InnoDB to ENGINE=InnoDB as MySQL 5.5 likes it.

Thanks,

Ernie

Posted by Ernie Ghiglione