The following is from http://codex.wordpress.org/Moving_WordPress:
If you forget to change the WordPress Address and Blog Address, you will be unable to change it using the wordpress interface. However, you can fix it if you have access to the database. Go to the database of your blog and find the wp_options table. This table stores all the options that you can set in the interface. The WordPress Address and Blog Address are stored as siteurl and home (the option_name field). All you have to do is change the option_value field to the correct URL for the records with option_name=’siteurl‘ or option_name=’home‘.
The Codex also has more detailed instructions elsewhere. But, basically, in cPanel, you need phpMyAdmin.
Thread Starter
lrl008
(@lrl008)
Thanks so much for your reply.
I am not sure where the database is located. Using cpanel access through file manager, I have gone to the public html and see all the folders for wordpress, but don’t see database or know quite where it is located.
Any further guidance would be helpful and I will go back and look again.
click on the phpmyadmin link in your host’s control panel
other methods
http://codex.wordpress.org/Changing_The_Site_URL
Thread Starter
lrl008
(@lrl008)
Again, thanks so much.
I will go try to do that.
By the way, just in case I can’t fix this, are the pages and actual content that I had done located someplace so that I could at least get the content that I have already done. For instance, I had written out privacy, disclosure, etc, but did not save them. I have a squeeze page as the home page, which I can access by going to main domain and copy source file. My links at bottom do not work and no tabs and cannot get to the other pages and posts.
Is there a way to retrieve them or the content from the files? Then I could just delete this blog and start over.
all info is stored in the databse – not in any wordpress files. That’s why it’s so important do back up your database.
http://codex.wordpress.org/Backing_Up_Your_Database
you should also back up theme files or other files you modify
if you really really need help – email me and I will
srb333 at att dot net
Thread Starter
lrl008
(@lrl008)
I found the table.
Field option_name
Do I actually change this option_name to http://www.domain.com or option_name=http://www.domain.com, or is it
option_name=’siteurl’ ?
and
Field option_value change to option_value=’http://domain.com’
I am not sure of the actual meaning of change. Exactly what gets typed in the field?
I hope this makes sense.
I think you should not not mess with this – I am afraid your knowledge is limited enough to mess it up
try one of the other methods mentioned here
http://codex.wordpress.org/Changing_The_Site_URL
that way if something goes wrong it can be more easily fixed
I just want to say THANK YOU. Because of this forum it saved me a grand headache!
