deddensweb

I have fixed the problem. In my case, the problem was with the table wp_options which was corrupted by the crash. Seems like the wordpress repair tool misdiagnosed.

In the future this problem can be fixed by:
1. Connecting to your server using SSH (Putty).
2. Go to the specific database folder using the command:
cd /var/lib/mysql/<databasename>
3. run the command:
myisamchk -r -f wp_options.MYI
(change to wp_options to the table which gives the error: is marked as crashed and last (automatic?) repair failed)
4. Your database should work again!

• This reply was modified 7 years, 1 month ago by deddensweb.
• This reply was modified 7 years, 1 month ago by deddensweb.

Update: Yes, but I think the problem doesn’t just have to do with woocommerce. When running MYSQL repair tool, I got the following error:
xxxxxx_wp1.wp_options repair error Can’t create new tempfile: ‘./xxxxxx_wp1/wp_options.TMD’

I think because of the crash it corrupted wp-options and now also the wp_woocommerce_termmeta is missing as a result?

Edit update 2 when running optimizer:
xxxxxx_wp1.wp_options optimize Error Table ‘./xxxxxx_wp1/wp_options’ is marked as crashed and last (automatic?) repair failed
xxxxxx_wp1.wp_options optimize Error Table ‘wp_options’ is marked as crashed and last (automatic?) repair failed

• This reply was modified 7 years, 1 month ago by deddensweb.
• This reply was modified 7 years, 1 month ago by deddensweb.
• This reply was modified 7 years, 1 month ago by deddensweb.