I was getting ready to take our WP site "live":

I was in Dashboard - Settings - General and was just getting ready to make the necessary changes, I inadvertently changed the WordPress Address (URL)

from http://www.hatchtown.com/wp/

to http://www.hatchtown.com

I then saved the change, AND THEN realized I'd meant to change the Blog Address NOT the WordPress address

I quickly re-set the AP addess back to include the /wp/ subdirectory, but it was too late. I can't get in, view the WP site, or anything.

Via my FTP program I can see that all the WP files, subdirectories, etc, are still there. How do I set this right?

Help! My wife's gonna kill me!

Try adding /wp-admin/ to both versions.

If you cannot login into any of them, try changing, with PHPMyAdmin, the value of the option "siteurl" (line1) or of the option "home" (~line 39-40) in the "wp_options" table in the Wordpress database, so that both values are identical again.

I've been in PHPMyAdmin and changed both option "siteurl" (line1) and option "home" (line 39) to BOTH read http://hatchtown.com/wp/ AND I've also tried http://hatchtown.com/ AND http://hatchtown.com/wp/blog ...the /blog had sort of appeared out of no where at some point.

BUT no matter what I try, I get either the short "Error establishing a database connection" or longer:

"Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at p50mysql127.secureserver.net. This could mean your host's database server is down.

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?"

I'm not sure what to do now. I do have an automatic backup from yesterday created by the plugin WP-DBManager. Do I have to re-install WP and then restore using the backup? I'm think ing that not being able to "boot" WordPress is a step worse than having the ability to run WordPress but not "see" my "Atahualpa site". This is my first "crash" so I don't know what to expect.

Note: a set of instructions I had from the WP Codex said that after I made the changes in the database that you'd suggested that I should:

"18. Delete the folder wp-content/cache (this is a new folder added with WordPress 2.0)."

I did do that.

How does this part of wp-config.php, located at the Wordpress root directory, look like

PHP Code:

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'putyourdbnamehere');

/** MySQL database username */
define('DB_USER', 'usernamehere');

/** MySQL database password */
define('DB_PASSWORD', 'yourpasswordhere');

/** MySQL hostname */
define('DB_HOST', 'localhost'); 


Edit your username and password before posting your code

Yep Flynn, your instincts were right. I had re-set the database password so it did not agree with what was showing in wp-config.php at

"/** MySQL database password */
define('DB_PASSWORD', 'MyPassword');"

Everything else, username, hostname and such were all okay. I put the new password in and uploaded the corrected wp-config.pho back into the wp root directory.

But, now if I go to log in I get a weird login screen -- sort of like the usual WP without the CSS. And if I do try to log in I get a "Page Not Found" error screen.

And the site is looking strange -- you can see it at http://hatchtown.com/wp/ -- if you click on some of the links to static pages you go up to the old index.html file in the top level www.hatchtown.com directory.

Eureka! It's all back! Once I was using the right database password AND had re-set the directory on lines 1 and 39 in the database AND waited a few minutes for that change to percolate through GoDaddy's system everything is back to the way it was.

I need a drink!

Thank you Flynn! Couldn't have done it without you!

Jim