Jump to content

wajdihab

Recommended Posts

You can convert the database to MyISAM as follows. This will also fix the #1874 (InnoDB read only) error:

  • Make a copy of the .sql file you want to import.
  • Search the copy of the .sql file for Engine=InnoDB and replace all instances with Engine=MyISAM
  • Create a new database.
  • Import the edited copy of the .sql into the database using PhpMyAdmin to restore the content.

We don't recommend using InnoDB on Stevie since the data gets lost or the server goes read-only quite regularly due to crashes.

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...