Table is 'read only'

mysql freebsd sql-update
Cyclone picture Cyclone · Mar 6, 2012 · Viewed 95k times · Source

When I want to execute an update query on my table I got an error saying:

1036 - Table data is read only.

How can I fix that?

Table attributes in /var/db/mysql are set to 777.

'Repair Table' function doesnt seems to help.

Is there anything I can do with that?

Answer

Rahi picture Rahi · Nov 4, 2016

In my case, mysql config file had innodb_force_recovery = 1. Commenting that out solved the issue. Hope it helps someone.

Related questions

Shell - one line query

I need to execute a mysql query in one line using bash. It should be something like this: mysql database --user='root' --password='my-password' < query.file But instead of the < query.file it would like to use a …

Read More
How do I find out the default server character set in mysql?

Using MySQL on FreeBSD 8.2. How do I find out the default server character set? Is there some command I can run or file I can check? UPDATE Actually I want to know how to find both the default server character …

Read More
MySQL Galera node not starting (aborting with Error 'WSREP: [...]: 60: failed to reach primary view: 60 (Operation timed out)')

I am trying to setup three Galera nodes on FreeBSD 10 with MySQL 5.6.26 and VirtualBox. When I set up everything and run MySQL, it exits after some time and cannot start properly. Here is my log: 2015-10-22 15:23:24 9402 [Note] WSREP: Read …

Read More