MySQL database in read only mode

[arduinod]

Hello, yesterday everything was working fine but today I can't add or edit data in my database. I am getting error: table fotot is in read only mode.

Any idea how to fix that?

Thanks

[wolstech]

You don't. InnoDB went corrupt on Johnny again (we highly recommend not using InnoDB because it goes corrupt if you so much as look at it wrong...Johnny is especially prone because load is high). You should make a backup of your data as soon as possible. If you really need InnoDB support, we recommend Ricky or Tommy.

 

Otherwise, once you make a backup, you can edit the backup to use MyISAM, create a new database, and restore the altered backup. You will not be able to drop the existing database, so you'll need to pick another DB name.