Thread: Changing URL's using cpanel phpmyadmin

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.