One or more database tables are unavailable – Completely confused!!!

Hey everyone,

I’ve searched high and low for a solution to this but still nothing that helps. I just used a plugin to change the table prefix.

Just after running it I get a “Error establishing connection to database” message. Unfortunately, being the noob I am I didn’t get a backup of the tables, just the WP site.

I tried the following:

1) added define(‘WP_ALLOW_REPAIR’, true); after define(‘DB_COLLATE’, ”);

went to /wp-admin

got the message
“One or more database tables are unavailable. The database may need to be repaired.”

click repair, and repair and optimise, on both cases got the following message:

The 2e5_users table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_users table. Error:

The 2e5_usermeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_usermeta table. Error:

The 2e5_posts table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_posts table. Error:

The 2e5_comments table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_comments table. Error:

The 2e5_links table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_links table. Error:

The 2e5_options table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_options table. Error:

The 2e5_postmeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_postmeta table. Error:

The 2e5_terms table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_terms table. Error:

The 2e5_term_taxonomy table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_term_taxonomy table. Error:

The 2e5_term_relationships table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_term_relationships table. Error:

The 2e5_commentmeta table is not okay. It is reporting the following error: . WordPress will attempt to repair this table…
Failed to repair the 2e5_commentmeta table. Error:

Then…

2) login to mySQL and repaired tables: It said all tables are OK

3) Went into wp-config and looked at the $table_prefix and it looks correct, it’s exactly what the new prefix on the tables on the table names.

4) Checked the database user name, host and password and all seem to be correct.

Completely lost as to what the problem is and the message I get doesn’t really show a error either.

I really need some help… I am completely lost and I don’t want to loose months of work by re-installing WordPress… Can anyone make heads or tails of this and point me in the right direction??

Thanks in advance for all your help!!
Jason

[No bumping, thank you. If it’s that urgent, consider hiring someone.]