Echographia

If you’ve just installed WordPress, say, for example, at http://echographia.com/blog, and then you started checking out the options, and you accidentally changed the WordPress address, say, for example, to http://echographia.com/, and now your CSS is all missing and if you try to change the settings you get redirected to a login script that doesn’t exist… and if you can get direct access to the SQL database… try something like this:

show tables;

Note the table whose name ends with options. I’m on a DreamHost one-click install of Wordpress, so I don’t know what it’s called in a standard installation. Let’s just say it’s called options.

update options set option_value = 'http://www.echographia.com/blog' where option_name = 'siteurl';