Hello, I have a WPMU installation running with several blogs with subdirs.
If I want to change that IP to something else, do I only need to edit the wp_site table (domain field)? Is the domain stored anywhere else?
Thanks.
Hello, I have a WPMU installation running with several blogs with subdirs.
If I want to change that IP to something else, do I only need to edit the wp_site table (domain field)? Is the domain stored anywhere else?
Thanks.
Yes, it is. The least obvious place is "guid" field in wp_*_posts table.
There are several places in wp_*_options, I believe.
*dupe*
run a php script that scrapes thru ur database and in every field where it finds the old ip....replace it with new id...
i hope ur gettin my point....
Go into phpmyadminadn do a search...
hmmmmmmm....
cant get a better option...
but if the database is big enuf how abt automating the process
You can download a backup, do a search/replace, and go from there.
* Random observation... *
I thought donncha had blocked IP based installations?
@luna - I thought he did too. Hmmm.
@ mite - phpmyadmin will generate the php script for you on that search & replace. :)
ohkkkk
dats cool andrea...
The only problem you may have with the find and replace method is if the IP has a different number of digits eg 10.1.1.100 to 10.1.1.1 and the IP/url is contained in some serialized data somewhere in the database. If this is the case you may need to manually change (or via a script) the length value (is that what it is called) for each occasion where the url is listed in serialized data.
Gee whiz that was wordy!
What about changing domain names? I've got a temporary domain name from my host while I set the site up, but when I go live how would I do that? Same way? WP is easier, in that you just change one setting in the options, and then physically move the files.
Same way - go into phpmyadmin, search for domain name, replace in every field.