Entering a wrong Worpress blog URL

If you running a wordpress blog on your own webspace, you have to enter the blog and wordpress URL under Admin Control Panel -> Settings. If you later change this address to a wrong one, your blog will not be working fine anymore. And since you entered the wrong URL you cannot login to the ACP, thus you can not change anything back. What's the key to get your blog running again?
2 answers

Entering a wrong Worpress blog URL SOLUTION

What you have to do is to connect to your database (either via terminal, or - if your provider offers you this solution, via the web mySQL Admin).

Now have a look at the wp_options table. if you do a select * you will recognize, that the entry with the option_id=1 has the name site_url. And the option_value is the wrong URL. Simply change this entry back to the write URL using UPDATE TABLE.....

Taggings:

Entering a wrong Worpress blog URL

Taggings: