I had updated as many plugins as I could find to make them compatible with 2.3 and meant to disconnect the rest before upgrading to WP 2.3 but I forgot that step.
The upgrade was successful, but both front and back ends were sluggish. Plugins were working ok as far as I could tell. I edited a couple pages and got error messages at the top of the blog with "wp_post2cat or wp_categories" errors. I tried a repair at MySQL and got error and when I check through MySQL I get this:
warning : Table is marked as crashed and last repair failed
warning : 20 clients are using or haven't closed the table properly
warning : Size of indexfile is: 15360 Should be: 11264
error : Not enough memory for blob at 71020
error : CorruptDecided to turn off all plugins but when try to get to dashboard now get these errors when I try to get to dashboard:
WordPress database error:
[Can't open file: 'wp_options.MYI'. (errno: 144)]
UPDATE wp_options SET option_value = 'O:8:\
"stdClass\":3:{s:12:\"last_checked\
";i:1191094705;s:15:\
"version_checked\";s:3:\
"2.3\";s:8:\"response\";s:6:\"latest\
";}'
WHERE option_name = 'update_core'
WordPress database error:
[Can't open file:
'wp_options.MYI'. (errno: 144)]
SELECT option_value FROM wp_options WHERE
option_name = 'db_version' LIMIT 1
Warning: Cannot modify header information -
headers already sent by (output started at /home/[myusername]/public_html/wp-includes/
wp-db.php:160) in /home/[myusername]/public_html/
wp-includes/pluggable.php on line 390Deleted all plugins by ftp except askimet and hello which came with 2.3 and maintenance-mode which was was suggested and which I had activated. Tried another repair, did not work.
I had backed up the datatase using wp-db-backup.php and it is in .sql.gz format.
Is there any way to repair other than a complete restore? Can I turn off plugins through PhpMyAdmin or the pluggable.php file? If not, can I import the .gz file or does it have to be unzipped first? How would I go about that?
Thanks!
Lois
