All geek questions in one place

InnoDB is not supported by the web host. Now what?

I was developing a small WAMP web application on my laptop, where I have an instance of mySQL, and I chose InnoDB for my DB engine. After several weeks of development, I wanted to make it available to the public and found out that the database server provided by my web host does not support InnoDB, but only MyISAM.

Created and created from the innoDB schema on my laptop, the created and populated script, when it is executed with a live database, can create separate tables, but then encounters the problems of creating VIEW. Views not supported in MyISAM? I know that FOREIGN KEYS are not. That's why I made InnoDB ... What are my chances for my innoDB schema project to work with myISAM?

Is there an easy way to convert an entire schema from one storage engine to another? Should I look for another web host that provides mysql db that supports innoDB?

+3
source share
3 answers

Your options:

  • Ask your web hosting provider if they can enable InnoDB on their servers (sometimes they will do this for you or transfer your account to a server that supports InnoDB).
  • Get a new InnoDB-enabled web hosting provider.
  • PHP (, Zend_Db Zend_Db_Table , , ).
  • MyISAM.

, 4 . --, InnoDB, MyISAM. , , , . , .

, , --.

+6

, InnoDB , ( ).

+2

it's not about InnoDB and MyISAM: views are supported in both types of tables. I think this is either a version problem ( Views [...] are available in MySQL Server 5.0 ), or about providing tables .

this will help if you post the exact error messages you receive.

0
source

Source: https://habr.com/ru/post/1733019/

More articles:


All Articles