Results 1 to 9 of 9

Thread: Changing URL's using cpanel phpmyadmin

  1. #1
    Thread Starter
    Member charterbase's Avatar
    Join Date
    Sep 2011
    Location
    United States
    Posts
    84
    Thanks
    37
    Thanked 3 Times in 3 Posts

    Changing URL's using cpanel phpmyadmin

    Am attempting to change from a test site URL I created to a permanent URL for a Vantage theme. Following previous advise I found these instructions to edit in cpanel phpmyadmin.

    I am NOT a php coder and have very limited experience in using cpanel phpmyadmin - so How to Guide says

    UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

    Do I just copy the bold, click insert at the top of the phpmyadmin page, paste into the value_option field, and change the urls similar to this image?
    Insert code.png

    If correct would the following be done in the same manner?

    After that you will need to fix URLs of the WordPress posts and pages, which translated from post slug, and stored in database wp_posts table as guid field. The URL values in this field are stored as absolute URLs instead of relative URLs, so it needs to be changed with the following SQL query:

    UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');

    If you have linked internally within blog posts or pages with absolute URLs, these links will point to wrong locations after you move the blog location. Use the following SQL commands to fix all internal links to own blog in all WordPress posts and pages:

    UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

    Thank you in advance.
    Last edited by charterbase; June 1st, 2012 at 03:33 PM. Reason: specify Vantage theme

  2. #2
    Veteran bluecafe's Avatar
    Join Date
    Apr 2010
    Location
    Berlin
    Posts
    1,563
    Thanks
    58
    Thanked 359 Times in 273 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. #3
    Thread Starter
    Member charterbase's Avatar
    Join Date
    Sep 2011
    Location
    United States
    Posts
    84
    Thanks
    37
    Thanked 3 Times in 3 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    Veteran bluecafe's Avatar
    Join Date
    Apr 2010
    Location
    Berlin
    Posts
    1,563
    Thanks
    58
    Thanked 359 Times in 273 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #5
    Thread Starter
    Member charterbase's Avatar
    Join Date
    Sep 2011
    Location
    United States
    Posts
    84
    Thanks
    37
    Thanked 3 Times in 3 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. #6
    Senior Member circlecity's Avatar
    Join Date
    Dec 2010
    Location
    United States
    Posts
    141
    Thanks
    15
    Thanked 14 Times in 13 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  7. #7
    Senior Member scorzaze's Avatar
    Join Date
    May 2012
    Location
    Virginia
    Posts
    122
    Thanks
    20
    Thanked 12 Times in 10 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  8. #8
    Thread Starter
    Member charterbase's Avatar
    Join Date
    Sep 2011
    Location
    United States
    Posts
    84
    Thanks
    37
    Thanked 3 Times in 3 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  9. #9
    Veteran bluecafe's Avatar
    Join Date
    Apr 2010
    Location
    Berlin
    Posts
    1,563
    Thanks
    58
    Thanked 359 Times in 273 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  10. The Following User Says Thank You to bluecafe For This Useful Post:

    charterbase (June 6th, 2012)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Restore a backup from cPanel
    By gr8job in forum Report JobRoller Bugs
    Replies: 5
    Last Post: April 16th, 2012, 08:38 PM
  2. Need help with creating more friendly URL's.
    By sancustreasures in forum ClassiPress General Discussion
    Replies: 2
    Last Post: October 20th, 2011, 09:47 PM
  3. i can't remove any file (filezila or filemanager-cpanel-plesk)????
    By billis in forum Report ClassiPress Bugs
    Replies: 6
    Last Post: October 6th, 2011, 04:20 PM
  4. [SOLVED] How can i add photo or Logo from the CPanel ?
    By harth in forum ClassiPress General Discussion
    Replies: 3
    Last Post: November 22nd, 2010, 05:05 PM