Posted 5 years ago #
I want to change the url of my blog.
I went to Options General tab and changed the
WordPress address (URL):
Blog address (URL):
then I changed the name of the directory on my web site's server
When I click the View site link
I get a File not found error with The referring document was: newurl/wp-admin/
Do I have to edit the wp-admin file with the new blog url?
Do I have to edit a table in the WordPress database?
Posted 5 years ago #
http://codex.wordpress.org/Changing_The_Site_URL
You might try searching before you ask for help.
Posted 5 years ago #
I am using putty to access the database for my blog on my server.
I am using mysql to change url of my blog.
I typed the command show tables;
Does anyone know which table has the field to update the new name?
My guess it might be the wp_options table.
If so, does anyone know the column name to run a select command?
Posted 5 years ago #
I went to http://codex.wordpress.org/Changing_The_Site_URL
I am using mysql to change url of my blog.
I typed the command show tables;
I typed
select * from wp_options where option_name = 'siteurl';
The result is 1 row in set
I typed
select * from wp_options where option_value = 'http://www.myurl/blog';
The result is 2 rows in set
My question is to change the URL in the database is the command?
update wp_options set option_value = 'http://www.newmyurl/blog' limit 1;
Is there another field that has to be updated in the other row?
[Look for the home field in the table]
I didn't find a home field in the wp_options table.
[Delete the folder wp-content/cache (this is a new folder added with WordPress 2.0).]
I am using WordPress 2.2.
I didn't find wp-content/cache folder on my server.
Why are you asking for mysql help here, is what I would like to know. The row info is one thing to ask for, but mysql has their own forums for questions on using mysql from the CLI.
Here is a gimme:
UPDATE wp_options SET option_value = 'http://www.blog.com' WHERE option_id =1;
Furthermore, youre asking for trouble running 2.0.2 -- no-one ought to help you except to say that you need to upgrade to 2.0.11
Posted 5 years ago #
You know what whooami, Inquire is asking legitimate questions. His question is not about how to use MySQL, but where options need to be changed. This is all about a community, and that's just no way to talk to a community member. If you don't want to help...don't, but there's no need to be taking someone to task for asking for help. That is not what the WordPress community is about.
Posted 5 years ago #
[Furthermore, youre asking for trouble running 2.0.2]
I am running WordPress 2.2.
I am not having trouble with this version.
Hi bjohnm:
[You know what whooami, Inquire is asking legitimate questions. His question is not about how to use MySQL, but where options need to be changed.]
Correct.
I am using MySQL versus phpAdmin, which phpAdmin is used in the instructions at the link
http://codex.wordpress.org/Changing_The_Site_URL
[You know what whooami, Inquire is asking legitimate questions.]
Thanks.
Yes, well youre asking for even more trouble running 2.2. When your blog is hacked, be sure to come back so I can say I told you so. :|
My question is to change the URL in the database is the command?
And guess what, asking how to use MySQL from the command line, isnt a WP question.
And youre welcome. You skipped over the fact that I gave you the damn MySQL command. I missed the part where the other person provided you any assistance. Ingrate.
Posted 5 years ago #
Hi whooami:
[And youre welcome. You skipped over the fact that I gave you the damn MySQL command. I missed the part where the other person provided you any assistance.]
Thank you.
[Ingrate.]
Keep spreading your goodwill to fellow members.
I spread plenty of goodwill -- more then enough to make up for you.
For future reference, MySQL has their own forums for questions regarding command line syntax:
Maybe now that you know how to do it, you can give back and add it to the codex.
This topic has been closed to new replies.
