So i was trying to import a database into MySQL server , and everything worked fine until i noticed that the storage engine is MyISAM , and we all know that MyISAM lacks support for some features , like:
1-) SQL Transactions
2-)Foreign keys
That’s why i find it mandatory to add support for the InnoDB storage engine , but here’s the question:
Is it possible to add this feature?
Thanks in advance.
EDIT:
I remember that InnoDB was supported before a while
EDIT 2: PLEASE , FOR THE SAKE OF EVERYTHING YOU LOVE , DON’T SUGGEST ME TO USE SET autocommit = 0 AS A WORKAROUND
@Eyad_Syria-lover said:
So i was trying to import a database into MySQL server , and everything worked fine until i noticed that the storage engine is MyISAM , and we all know that MyISAM lacks support for some features , like:
1-) SQL Transactions
2-)Foreign keys
That’s why i find it mandatory to add support for the InnoDB storage engine , but here’s the question:
Is it possible to add this feature?
Thanks in advance.
EDIT:
I remember that InnoDB was supported before a while
EDIT 2: PLEASE , FOR THE SAKE OF EVERYTHING YOU LOVE , DON’T SUGGEST ME TO USE SET autocommit = 0 AS A WORKAROUND
Simple Answer:
InnoDB is NOT supported on free hosting and you should consider upgrading to premium
InnoDB uses quite a bit more memory than MyISAM last time I checked, which is why it’s not available on free hosting (and it hasn’t been available in the past either, as far as I can remember).