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

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