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

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