The IP address of your server is not stored in the database, unless you specifically entered an IP address rather than a domain name for the “home” URL.
What problem(s) are you experiencing as a result of the IP address change?
I have been using a template for my site, so when the IP address changes, the stylesheet does not load and the links are all showing the old IP address. Last time, the only way to fix this was to delete the database, which means I lost my blog. I searched all the files in wordpress for the IP address and it wasn’t anywhere, so I had to delete the database.
Whatever frame lives at http://lovesit.net/ is where the IP address is. You’ll need to edit that file some how.
The siteurl and home values are in the database. If you have phpmyadmin, you can change them by following this:
http://www.tamba2.org.uk/wordpress/site-url/
You can also change these values through the command line:
shell> mysql DBNAME -u USERNAME -p
mysql> show tables;
(use the table name with _options in the next commands if you changed the table prefix)
mysql> update wp_options set option_value=”NEWPREFIX” where option_name=”siteurl”;
mysql> update wp_options set option_value=”NEWPREFIX” where option_name=”home”;
Just replace NEWPREFIX with the new IP or domain name like “http://new.domain.com/path/to/wordpress”.
I haven’t tried this yet, but I think if you make one blank, the site will get relative URLs instead of prefixing all links with the siteurl.
Brilliant! Worked very well, thanks.
