InnoDB is in read only mode.

[solooo7]

johnny.heliohost.org

 

 

I'm trying to connect mysql from node. It shows

InnoDB is in read only mode

when I write/update/drop tables.

Please help.

 

It was working properly before. Suddenly it started showing this error.

Edited February 23, 2018 by solooo7

[wolstech]

We're aware. InnoDB on Johnny is damaged. We recommend MyISAM for exactly this reason...InnoDB breaks way too easily (we've lost an entire server's worth of InnoDB data numerous times, but have never lost a MyISAM table in our 10+ years in operation). For now, the only thing you can (and should) do is back up your data while it's accessible.

 

The failure was caused by the servers being improperly shut down due to a power outage at HE the other day. The entire data center went down, not just us.

 

When we attempt to repair it, it's quite likely that some or all of the data will be lost, so there's a good chance you'll need the backups to get your site working again.

[alexteal]

How do i back up my data & and where can i find the MyISAM database?

[Krydos]

You can backup everything (including databases) at:

https://johnny.heliohost.org:2083/frontend/paper_lantern/backup/index.html

 

You can change your storage engine with this code:

ALTER TABLE table_name ENGINE = MyISAM;

Also we highly recommend taking frequent backups. Take a backup after each major change to your site, and also once a week or so would be a good idea.

[kdufoc]

I can't install Joomla. Receive the same error. How can I now install it?

[wolstech]

You can't, unless you want to try modifying the installer. Usually there's a folder of .sql files that the installer imports. You could edit these to change the engine flag to MyISAM and see if the program will work. Some applications require the functionality of InnoDB though and won't work if you convert their tables.

 

If you don't want to wait until this is fixed, you can move to Ricky (http://wiki.helionet.org/Moving_your_account, free registrations open at midnight UTC every day) or Tommy (https://heliohost.org/tommy/, no free sign ups, donation required) where we have working InnoDB support.