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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Aaron Robertshaw

    (@aaronrobertshaw)

    3 years ago

    Hi @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.

    Failing that, Bitnami should be able to help debug your database permissions further.

    I hope that helps!

    Thread Starter vgnavada

    (@vgnavada)

    3 years ago

    Hi @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.
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.