Changing the URL directly in the database

  • jbento

    (@jbento)


    14 years ago

    I am doing the below instructions, but I am stuck on one part of it, which is this:

    16. In the input box for option_value, carefully change the URL information to the new address.

    I am trying to find the input box for the “option_value” column and I can’t.

    Can someone please help me???

    ——————————————————

    Changing the URL directly in the database

    If you know how to access phpMyAdmin on your host, then you can edit these values directly to get you up and running again.

    1. Backup your database and save the copy off-site.
    2. Login to phpMyAdmin.
    3. Click the link to your Databases.
    4. A list of your databases will appear. Choose the one that is your WordPress database.
    5. All the tables in your database will appear on the screen.
    6. From the list, look for wp_options. Note: The table prefix of wp_ may be different if you changed it when installing.
    7. Click on the small icon indicated as Browse.
    8. A screen will open with a list of the fields within the wp_options table.
    9. Under the field option_name, scroll down and look for siteurl.
    10. Click the Edit Field icon which usually is found at the far left at the beginning of the row.
    11. The Edit Field window will appear.
    12. In the input box for option_value, carefully change the URL information to the new address.
    13. Verify this is correct and click Go to save the information.
    14. You should be returned to your wp-options table.
    15. Look for the home field in the table and click Edit Field. Note There are several pages of tables inside wp_options. Look for the > symbol to page through them.
    16. In the input box for option_value, carefully change the URL information to the new address.
    17. Verify this is correct and click Go to save the information.
    18. Delete the folder wp-content/cache (this is a new folder added with WordPress 2.0).
    19. That is it.

Viewing 10 replies - 1 through 10 (of 10 total)
  • Moderator t-p

    (@t-p)

    simply put:

    access your WordPress database via phpMyAdmin and manually check, in the wp_options table, the siteurl and home values and make sure they are correct.

    For example, in WP3.0.1, this (wp_options) is the fourth table

    Table Name:

    wp_options

    here “wp” is the default table prefix. You may have different prefix.

    Thread Starter jbento

    (@jbento)

    yes i did the below:

    wp_options table, the siteurl and home values and make sure they are correct.

    BUT

    when I come to this part: 16. In the input box for option_value, carefully change the URL information to the new address.

    I can’t find that.

    That is what I need help with.

    Thanks,

    Thread Starter jbento

    (@jbento)

    i am specifically looking for what they are calling the input box.

    where in the world is the input box for option_value?

    Joseph

    (@jpe24524)

    Click the pensil (edit) icon to edit the value.

    Thread Starter jbento

    (@jbento)

    if you go to that area, this is the column with the header “option_value”

    under the option_value there are many fields, but it asking for me to go to the input box for “option_value” which is the header only, so I can’t find an input box for “option_value”

    remember, option_value is not a field, it is the column, so that is what is confusing me.

    Moderator t-p

    (@t-p)

    That’s why I stated in simple terms:

    simply put:

    access your WordPress database via phpMyAdmin and manually check, in the wp_options table, the siteurl and home values and make sure they are correct.

    Thread Starter jbento

    (@jbento)

    i have already those items, which are in earlier steps.

    step 16 is what i am on and stuck on

    Joseph

    (@jpe24524)

    Once you’re inside (broswing) the wp_options table
    1. Look for the row that you want to edit,
    2. Click the pensil icon for that row,
    3. Change the URL in option_value, a text box, and
    4. Click Go to finalise the edit.

    Thread Starter jbento

    (@jbento)

    i have already done those items, which are in earlier steps.

    step 16 is what i am on and stuck on

    Joseph

    (@jpe24524)

    I am referring to step 16:

    16. In the input box for option_value, carefully change the URL information to the new address.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Changing the URL directly in the database’ is closed to new replies.