How to use to CHANGE DOMAIN name only

  • Resolved IRD-dev

    (@ird-dev)


    8 years, 7 months ago

    Hello.
    Can this plugin assist and, if so – how, with moving a WordPress with WooCommerce site from a DEVELOPMENT URL to a Production URL .. all on the same server + hosting account?

    I am developing a customer’s NEW WordPress + WooCommerce site on a development server. The development URL is: http:\\clientname.net.temp.mydevhost.com\

    The customer’s domain name remains pointed at their “OLD” webserver / website, until the new site is ready for production go-live.

    Once approval is obtained, I will alter their DNS records to direct to the “development” server and, hence, I will need to update their new WordPress+WooCommerce website by changing the URL from:

    http:\\clientname.net.temp.mydevhost.com\
    to
    http:\\clientname.net\

    I’ve used the Velvet Blues plugin, in the past, but it was incomplete at best.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter IRD-dev

    (@ird-dev)

    *bump*

    Hey Ird-dev,

    It should handle the URL update and move for you, but none of the DNS steps will it handle.

    Thanks~

    Just go to Settings>General and change the URL’s there, this will update some important parts of the database… After that you can change the Domain Name’s DNS records to point to the new host… While the DNS is propagating you can login to your database manager (like phpmyadmin) and do a search and replace for any instance of “clientname.net.temp.mydevhost.com” to be replaced to “clientname.net”, that will fix any links throughout the site… You’ll need to run the search/replace on each table/column that it’s found in, but shouldn’t take too long… There’s also your server config to do as well, if you’re using a shared hosting account or a VPS, need to change the settings to let the server/hosting-account know there is a new website present…

    Thread Starter IRD-dev

    (@ird-dev)

    Thank you for replying. Due to time constraints, I ended up leveraging a different plugin “Search & Replace” which (at the time) was unable to support my special scenario.

    In the end, I used that plugin’s “Dry Run” report as a reference, and swept the WPDB using phpMyAdmin.

    For example, I used the following SQL command to update the list of WP tables below:

    UPDATE wp_comments
SET comment_author_email = REPLACE(comment_author_email, 'clientname.net.temp.mydevhost.com', 'clientname.net')
WHERE comment_author_email LIKE '%clientname.net.temp.mydevhost.com%'

    Tables : columns manually updated:

    wp_comments : comment_author_email
wp_layerslider : data
wp_options : option_value
wp_postmeta : meta_value
wp_posts : post_content
wp_posts : guid

    As for changing the DNS, etc, I was already familiar but do appreciate the insight nonetheless. My issue was solely looking for an automation tool to search the various WP tables and perform the aforementioned change in one felled swoop.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How to use to CHANGE DOMAIN name only’ is closed to new replies.