The table ‘wp_options’ is full

  • Resolved honkin

    (@honkin)


    2 years ago

    When trying to restore the db from a recent backup, I got the above message and the back failed and now the db is messed up. I can still access the site, but cannot activate or deactivate plugins, the media library doesn’t show and all images are missing in pages and not sure what else right at the moment. Thankfully it is the staging server, so no huge issue, but need it resolved

    • This topic was modified 2 years ago by honkin.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    To help us work out the cause of your problem, can you please send us a copy of the restoration log?
    You can find this log in the ‘wp-content/updraft’ directory of your site via FTP.
    You can send the log file as an attachment or copy the contents into an online tool (such as https://pastebin.com/ )

    Best Wishes,
    Bryle

    Thread Starter honkin

    (@honkin)

    0000.010 () Opened log file at time: Sun, 12 Mar 2023 04:35:28 +0000 on https://wordpress-102462-558755.cloudwaysapps.com
    0000.010 () UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.22.24 WP: 6.1.1 PHP: 8.0.23 (fpm-fcgi, Linux 102462.cloudwaysapps.com 4.19.0-21-amd64 #1 SMP Debian 4.19.249-2 (2022-06-30) x86_64) MySQL: 10.4.20-MariaDB-1:10.4.20+maria~buster-log (max packet size=134217728) WPLANG: en_AU Server: Apache/2.4.54 (Debian) safe_mode: 0 max_execution_time: 900 memory_limit: 512M (used: 35.9M | 40M) multisite: N openssl: OpenSSL 1.1.1n 15 Mar 2022 mcrypt: N LANG: ZipArchive::addFile: Y
    0000.010 () Free space on disk containing Updraft’s temporary directory: 11625.1 MB

    Thread Starter honkin

    (@honkin)

    There was not that much in the log file, so was easy enough to just paste it here

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    Hi,

    That’s not the right log file – no restore has been started in that log file; you need to look for another one.

    David

    Thread Starter honkin

    (@honkin)

    Cheers for your reply. In the end, it was far too cumbersome trying to supply the log files, ALL of which had that same content you saw. Instead, I simply pulled all the data from my live site back to the staging server and it is fine. Now it is fine, though not sure I’ll be utilising the free version of the plugin again

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘The table ‘wp_options’ is full’ is closed to new replies.