Want to change the url of my blog

https://codex.www.ads-software.com/Changing_The_Site_URL

You might try searching before you ask for help.

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?

I went to https://codex.www.ads-software.com/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 = ‘https://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 = ‘https://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 = 'https://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

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.

[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

https://codex.www.ads-software.com/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.

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:

https://forums.mysql.com/

Maybe now that you know how to do it, you can give back and add it to the codex.