dboth

OK, here is what I finally did to fix this.

I used mysqlcheck on the new web site against the “wordpress” database. This fixed some of the databases, but also showed errors in several others including the wordpress internal datbases. I repaired most of the databases using REPAIR TABLE and ran mysqlcheck again and some of the databases supposedly repaired were still shown as having errors. I then repaired the wordpress internal databases and checked those and they were now OK. I then went back and repaired the rest of the tables.

At this point the problematic web site was working but with some real strangeness. At first it still showed a blank white page. I recalled having run into something similar previously and so I changed themes. Some themes worked but would not show the content of pages although posts were fine and others worked as expected.

At this point I rebooted the host and everything now works fine and as expected with my own preferred theme.

Thanks for your help and suggestions.

I will try that tomorrow. Thanks!

I did not do a dump/reload. I have not tried to repair using PHPMyAdmin. I did the “repair table” suggested in the error messages. If you think a dump/reload will work better I can try that. Would you suggest I dump from the currently working host and reload to the broken one or dump from the non-working one and reload it then?

Thanks!

Yes I did. See the post above. It still fails.

Here are the errors that show up when I press the “Repair” button. After manually repairing the tables, I get a blank screen when trying to access the content and then the dashboard when I go back to wp-admin. I tried this again this morning and these are the errors.

I stopped mysqld on both hosts, created the tarball of the entire /var/lib/mysql directory, copied the tarball to the new host, untarred the tarball into /var/lib/mysql, started mysqld and tested. Same result as before except that only one of my sites is having a problem instead of two.

millennium_users: Table upgrade required. Please do “REPAIR TABLE millennium_users” or dump/reload to fix it!
millennium_usermeta: Table upgrade required. Please do “REPAIR TABLE millennium_usermeta” or dump/reload to fix it!
millennium_posts: 1 client is using or hasn’t closed the table properly
millennium_links: Table upgrade required. Please do “REPAIR TABLE millennium_links” or dump/reload to fix it!
millennium_options: Table is marked as crashed
millennium_postmeta: Table upgrade required. Please do “REPAIR TABLE millennium_postmeta” or dump/reload to fix it!
millennium_terms: Table upgrade required. Please do “REPAIR TABLE millennium_terms” or dump/reload to fix it!
millennium_term_taxonomy: Table upgrade required. Please do “REPAIR TABLE millennium_term_taxonomy” or dump/reload to fix it!

Thanks for helping.

I will have to retry and post them. I thought I had copied them to clipboard, but The page was gone and the clipboard overwritten.