WordPress.org

Ready to get started?Download WordPress

Forums

Want to change the url of my blog (10 posts)

  1. Inquire
    Member
    Posted 6 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?

  2. kmessinger
    Volunteer Moderator
    Posted 6 years ago #

    http://codex.wordpress.org/Changing_The_Site_URL

    You might try searching before you ask for help.

  3. Inquire
    Member
    Posted 6 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?

  4. Inquire
    Member
    Posted 6 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.

  5. whooami
    Member
    Posted 6 years ago #

    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

  6. bjohnm
    Member
    Posted 6 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.

  7. Inquire
    Member
    Posted 6 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.

  8. whooami
    Member
    Posted 6 years ago #

    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.

  9. Inquire
    Member
    Posted 6 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.

  10. whooami
    Member
    Posted 6 years ago #

    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:

    http://forums.mysql.com/

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

Topic Closed

This topic has been closed to new replies.

About this Topic