Title: WordPress database error: [Table ‘wp_options’ is read only]
Last modified: April 13, 2023

---

# WordPress database error: [Table ‘wp_options’ is read only]

 *  Resolved [vgnavada](https://wordpress.org/support/users/vgnavada/)
 * (@vgnavada)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_options-is-read-only/)
 * Hello,
 * I’m unable to login to the site: [https://karavalixpress.com/](https://karavalixpress.com/)
 * It is running on “**WordPress with NGINX and SSL packaged by Bitnami**” on Amazon
   ec2.
 * I also raised a ticket on Bitnami Forums: [https://github.com/bitnami/vms/issues/837](https://github.com/bitnami/vms/issues/837)
   
   Looks like they don’t have any insights into this
 * I enable the DEBUG MODE, And found these major errors:
 * **WordPress database error:** [Table ‘wp_options’ is read only]
   `UPDATE ``wp_options`
   SET `option_value` = '1681396523.5065269470214843750000' WHERE `option_name` 
   = '_transient_doing_c
 * **WordPress database error:** [Table ‘wp_usermeta’ is read only]
   `UPDATE ``wp_usermeta`
   SET `meta_value` = 'a:1:{s:64:\"1710e0695c0eb73e731b74b7ba52d26644fc0ae647c48e7c927b5832e090d2ba\";
   a:4:{s:10:\"expiration\";i:1681569323;s:2:\"ip\";s:14:\"162.158.235.63\";s:2:\"
   ua\";s:117:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36(
   KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36\";s:5:\"login\";i:1681396523;}}'
   WHERE `user_id` = 4 AND `meta_key` = 'session_tokens'
 * Can anyone help me how to fix this?
    -  This topic was modified 3 years, 1 month ago by [vgnavada](https://wordpress.org/support/users/vgnavada/).
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-table-wp_options-is-read-only%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Aaron Robertshaw](https://wordpress.org/support/users/aaronrobertshaw/)
 * (@aaronrobertshaw)
 * [3 years ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_options-is-read-only/#post-16653886)
 * Hi [@vgnavada](https://wordpress.org/support/users/vgnavada/)
 * As those errors notes, it appears your database tables are read-only. The first
   things that come to mind are:
    - Checking the MySQL user associated with your WordPress installation has the
      necessary permissions to read and write to the database.
    - Perhaps repairing the database via the built-in WordPress database repair 
      feature.
 * You can find some further information on the latter in the [developer docs](https://developer.wordpress.org/apis/wp-config-php/#automatic-database-optimizing).
 * Failing that, Bitnami should be able to help debug your database permissions 
   further.
 * I hope that helps!
 *  Thread Starter [vgnavada](https://wordpress.org/support/users/vgnavada/)
 * (@vgnavada)
 * [3 years ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_options-is-read-only/#post-16655908)
 * Hi [@aaronrobertshaw](https://wordpress.org/support/users/aaronrobertshaw/) ,
 * I was able to over come this issue by doing as follows:
    1. Backing up all individual tables in the effected DB manually and exporting it
    2. Creating a separate / new ec2 instance
    3. Manually importing the previously backed up DB tables one by one to the new 
       instance’s DB
    4. Manually migrating the themes, plugins and uploads folders using SFTP.
 * Thanks!
    -  This reply was modified 3 years ago by [vgnavada](https://wordpress.org/support/users/vgnavada/).

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress database error: [Table ‘wp_options’ is read only]’ is closed
to new replies.

## Tags

 * [database issue](https://wordpress.org/support/topic-tag/database-issue/)
 * [Login Issue](https://wordpress.org/support/topic-tag/login-issue/)
 * [WordPress database error](https://wordpress.org/support/topic-tag/wordpress-database-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [vgnavada](https://wordpress.org/support/users/vgnavada/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_options-is-read-only/#post-16655908)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics