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


 
You may request notification for Dose lams2.3.4 support mysql5.5?.
Search: 

1: Dose lams2.3.4 support mysql5.5?
01/12/11 12:37 AM
[ Reply | Forward ]
I change the lams database version from 5.1 to 5.5. And when I run the rebulid-db ant order,many sql version error occur. May be I had knew the answer of this topic. But I want to does anyone experiencing the same thing?

Posted by leo luo

2: Re: Dose lams2.3.4 support mysql5.5?
In response to 1 01/12/11 04:54 AM
[ 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

3: Re: Dose lams2.3.4 support mysql5.5?
In response to 1 01/12/11 10:12 AM
[ 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

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