Change Database engine

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
Nadrah
Posts: 7
Joined: Fri Dec 29, 2017 12:57 pm

Change Database engine

Post by Nadrah »

hello
Can I change database engine from MyISAM to Innodb because I want change database to add foreign keys to tables
Thanks
Klemen
Site Admin
Posts: 10145
Joined: Fri Feb 11, 2005 4:04 pm

Re: Change Database engine

Post by Klemen »

On MyISAM is officially supported at the moment.

I presume it should work OK if you have MySQL 5.6+ on the server as fulltext searches have been added to InnoDB in 5.6.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Nadrah
Posts: 7
Joined: Fri Dec 29, 2017 12:57 pm

Re: Change Database engine

Post by Nadrah »

Klemen wrote: Thu Jan 04, 2018 2:40 pm On MyISAM is officially supported at the moment.

I presume it should work OK if you have MySQL 5.6+ on the server as fulltext searches have been added to InnoDB in 5.6.
Yes U have MySQL5.6.12 so I can change it because I want to add foreign key to tables of db of HESK system
Post Reply