Need to replace IP address with FQDN in WP database (3 posts)

  1. emaneric
    Posted 1 year ago #

    Due to circumstances beyond my control, I had to build a WP web site in the public folder of a hosting account that could only be accessed by it's IP address rather than a fully qualified domain name (FQDN). The intended FQDN has now been pointed to the IP address and successfully resolves to the home page however all subsequent pages, posts, images, documents etc. continue to link through the IP address as one would expect.

    If possible I would like to do a global search and replace through the WP database (MySQL) and substite the FQDN for the IP address rather than try to edit all of the posts, pages, links, etc. in the WP backend.

    Is there a step by step process to accomplish this? (I rarely tinker direct to the WP database.) I trust some changes would also be necessary in the htaccess files and wp-config file. Or maybe some kind of redirect in the htaccess file(s) could make the FQDN appear rather than the IP address to the outside world.

    The site is at http://www.staugpres.org.

    Please advise.

    Thank you.


  2. emaneric
    Posted 1 year ago #

    BTW, I already know about changing the IP address to the FQDN under Wettings > General and I 've done that. It's the rest of the "hard-coded" links/URLs I am concerned about.

    Thank you.


  3. WPyogi
    Forum Moderator
    Posted 1 year ago #

    There are plugins that will do the find/replace for you -




    Make sure you backup your DB before doing anything!

Topic Closed

This topic has been closed to new replies.

About this Topic