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)?
It was, thank you. Not sure why Webmin has it as unavailable. I am the server admin (this is my server with my sites on it) and I couldn’t install it. However it was available in Virtualmin.
Unfortunately it couldn’t be installed because of a disk quota issue that I have.
Unfortunately, when I try to get into MariaDB Server, it just gives me the error that a table ‘is marked as crashed and last (automatic?) repair failed’. I can’t look at the database to repair it, hence why I thought I’d install PHPMyAdmin, unless there is another way to see the database?