It sounds like your database may have run out of space. Check with your host to see if you’ve run into any quotas.
Thread Starter
zgall1
(@zgall1)
I am hosting the site. There is still significant space on the server and no other sites on the same server are experiencing any issues.
How much space is left in your /tmp partition?
df -h /tmp
is there about twice the size of the wp_options table?
Thread Starter
zgall1
(@zgall1)
When I run that command, I get these results.
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 155G 138G 18G 89% /
OK, then that’s not it, probably. What’s the size of your wp_options table when viewed from PHPMYADMIN or the command line?
What happens if you try to repair the database from the command line using “mysqlcheck”?
Thread Starter
zgall1
(@zgall1)
The options table is 0B when viewed through PHPMyAdmin.
This is what I see when I run mysqlcheck.
chem_ecol.wp_811489daf7_options
warning : Table is marked as crashed and last repair failed
warning : 1 client is using or hasn't closed the table properly
error : Record at pos: 906060 is not remove-marked
error : record delete-link-chain corrupted
error : Corrupt
It looks to me like you’ll need to restore your database from your most recent backup.
But first, one more try:
mysqlcheck --repair chem_ecol wp_811489daf7_options
Thread Starter
zgall1
(@zgall1)
This is what I got.
chem_ecol.wp_811489daf7_options
error : Can’t create new tempfile: ‘./chem_ecol/wp_811489daf7_options.TMD’
status : Operation failed
Can I restore only that table or do I need to restore the entire database?
Well, if the backup isn’t too old, try just the table.