We're moving our WordPress site from our hosting company to in-house hosting, on a Windows 2008 R2 server, without IIS.
I received the WordPress site from our hosting company in a zip file with associated MySQL database *.sql file. I installed WAMP and got the site running locally. I transferred and installed the site to a production server that is intended to eventually host the site externally.
The site is now working locally on the production server. I have a few specific questions, but first here are a few facts (these are only examples, and not real:
The site currently is hosted by a hosting service, ABC Hosting Service, Inc.
The site is visited by typing in the address http://www.mysweetfruitpies.com
In the MySQL database I originally received from ABC Hosting Service, Inc., in various keys and in various tables is
"http://abchosting.com/fruitpies", For example, the *.sql file contains the text:
, 'siteurl', 'http://abchosting.com/fruitpies', 'yes'),
'home', 'http://abchosting.com/fruitpies', 'yes'),
It contains strings of text such as:
In addition, there are *.php and *.html files in the WordPress site directory structure that also contain "http://abchosting.com/fruitpies".
The internal IP of our in-house server is 192.168.123.123.
To get the site to run locally, and also on the in-house server, I created a folder beneath \wamp\www called "fruitpies", so the WordPress directory structure is in \wamp\www\fruitpies.
I also ran SQL scripts to change the "http://abchosting.com" in the MySQL tables to "http://192.168.123.123". I also similarly modified any references in the *.php and *.html files.
In the wp-admin General Settings, the "WordPress address" reads "http://192.168.123.123/fruitpies". The "Site address" reads
By doing the above, I can run the site in the browser of the in-house server by typing in "http://192.168.123.123/fruitpies".
It shows tabs at the top which link to other pages within the site, and displays graphical images.
Then the network administrator put the site outside the firewall, and in the router translated the internal address into an external address (or the reverse). The external address is "220.127.116.11".
When you go to an external browswer and type in "http://18.104.22.168/fruitpies", the site displays, but the instead of tabs there is a
bulleted list, and the graphics don't display, but show a red "x". The reason is it's trying to find each graphics file at
"http://192.168.123.123". If you click one of the links in the bulleted list, it gives a "Web page not available". The reason is it's trying to access the page at "http://192.168.123.123".
Now if I go into wp-admin General Settings and change the "WordPress address" from "http://192.168.123.123/fruitpies" to
"http://22.214.171.124/fruitpies", and I then call up "http://126.96.36.199/fruitpies" on an external browser, it now shows the tabs ok (no more bulleted list). But clicking on the tab links still display "Web page not available". And it still shows red x's where the graphics files should be.
So my questions are these (I need specific answers, not general ones):
In order to get the site to display correctly when accessing from an external browser:
1) What specifically should the wp-admin General Settings "WordPress address" read?
2) What specifically should the wp-admin General Settings "Site address" read?
3) What specifically should the "http://abchosting.com" in the MySQL database and in *.php and *.html WordPress files be changed to?
4) What should be the specific address typed in the browser window to call up the site externally?
And my final question - when the DSN name server for "mysweetfruitpies.com" is finally changed to equate to 188.8.131.52, what specifically should the answers to questions 1 - 4 be.
NOTE: I've read all the WordPress documents about "moving your site" and "changing the site URL", and for me they do not answer the above