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


 
Search: 

4: Re: Re: Dose lams2.3.4 support mysql5.5?
In response to 3 01/13/11 11:35 PM
[ 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

5: Re: Re: Re: Dose lams2.3.4 support mysql5.5?
In response to 4 02/25/11 07:18 AM
[ 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

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum