Help Please With WordPress It Keeps Going Round In Circles!

kah22

OK I'll admit it I was watching the match and trying to work the computer at the same time and have landed my self in the s..t. Anyway here's my problem

I completely removed my copy of WordPress and deleted the database. I then re-installed WordPress, carried out all the necessary adjustments and went to http://mysite.com/wp-admin/install.php but got the message that ‘One or more database tables are unavailable. The database may need to be repaired.’ Went through the desired procedure with the results below

The wp_users table is okay.
The wp_users table is already optimized.
The wp_usermeta table is okay.
The wp_usermeta table is already optimized.
The wp_posts table is okay.
The wp_posts table is already optimized.
The wp_comments table is okay.
The wp_comments table is already optimized.
The wp_links table is okay.
The wp_links table is already optimized.
The wp_options table is okay.
Successfully optimized the wp_options table.
The wp_postmeta table is okay.
The wp_postmeta table is already optimized.
The wp_terms table is okay.
The wp_terms table is already optimized.
The wp_term_taxonomy table is okay.
The wp_term_taxonomy table is already optimized.
The wp_term_relationships table is okay.
The wp_term_relationships table is already optimized.
The wp_commentmeta table is okay.
The wp_commentmeta table is already optimized.
Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.
define('WP_ALLOW_REPAIR', true);

Removed the line above and went back to http://mysite.com/wp-admin/install.php but again get the message that One or more database tables are unavailable. The database may need to be repaired.
It keeps going around in circles.

In case some files were corrupted I did another complete re-install, didn't touch the database though and still getting the same result

Any suggestions, and idea of what might be happening?
Kevin

S0litaire

Few people have had this problem.
Do you have access to 'phpmyadmin' ?
If so go to the Wordpress database and find the config table and look for the URL value (it will be blank!) change it to your website address)

The problem might be that the repair removed your site's URL from the database.

If you don't have access to "phpmyadmin" but have access to the SQL console try the following: (replace <YOURURL> with your website address!)

UPDATE YOUR DATABASE NAME.wp_options SET option_value =  'http://<YOURURL>'  
WHERE wp_options.option_id =2 LIMIT 1 ;

Things should now be running (no need to run the repair again!!)


http://wordpress.org/support/topic/error-establishing-a-database-connection-171

kah22

SOlitaire thanks for the advice.

Talk to my ISP F2S and they advised just deleting every table, one by one, and then running the WP instalation again. Didn't mind adopting this approach as I intend to take my blog in a new direction. Worked perfectly first time. Problem solved