Hi. I have an issue with a Wordpress site. It has a corrupt table. I tried a repair using Wordpress but:
WordPress will attempt to repair this table…
Failed to repair the domainuser_options table. Error: Can’t create new tempfile: ‘./domainuser_wordpress/xxx_options.TMD’
There is storage space on the account. I’m using MariaDB Server, and if I go into that on Webmin, I get this:
SQL show index from
xxx_commentmeta failed : Table ‘./domainuser_wordpress/xxx_commentmeta’ is marked as crashed and last (automatic?) repair failed
This stops anything else from loading on that page.
I have SSH access but running this is similar to the Wordpress fix:
myisamchk -o /var/lib/mysql/domainuser_wordpress/xxx_options
recovering (with keycache) MyISAM-table ‘/var/lib/mysql/domainuser_wordpress/xxx_options’
Data records: 11918
myisamchk: error: Can’t create new tempfile: ‘/var/lib/mysql/domainuser_wordpress/xxx_options.TMD’
I have a backup that’s about 2 months old. I’d be happy to install PHPMyAdmin on Webmin as I have more experience with that, but I see that’s not supported as an install script any more. Is this the way forward or can you give me advice on how best to repair those corrupt table(s)?
Thanks in advance!
|OS type and version
|Alma Linux 8.8