The MU forums have moved to WordPress.org

Changing domains. (12 posts)

  1. naijin
    Member
    Posted 16 years ago #

    Hello, I have a WPMU installation running with several blogs with subdirs.

    i.e. http://10.1.1.100/wp/

    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.

  2. gombo
    Member
    Posted 16 years ago #

    Yes, it is. The least obvious place is "guid" field in wp_*_posts table.

    There are several places in wp_*_options, I believe.

  3. gombo
    Member
    Posted 16 years ago #

    *dupe*

  4. miteshashar
    Member
    Posted 16 years ago #

    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....

  5. andrea_r
    Moderator
    Posted 16 years ago #

    Go into phpmyadminadn do a search...

  6. miteshashar
    Member
    Posted 16 years ago #

    hmmmmmmm....
    cant get a better option...
    but if the database is big enuf how abt automating the process

  7. lunabyte
    Member
    Posted 16 years ago #

    You can download a backup, do a search/replace, and go from there.

    * Random observation... *
    I thought donncha had blocked IP based installations?

  8. andrea_r
    Moderator
    Posted 16 years ago #

    @luna - I thought he did too. Hmmm.

    @ mite - phpmyadmin will generate the php script for you on that search & replace. :)

  9. miteshashar
    Member
    Posted 16 years ago #

    ohkkkk
    dats cool andrea...

  10. mysorehead
    Member
    Posted 16 years ago #

    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!

  11. jonlandrum
    Member
    Posted 16 years ago #

    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.

  12. andrea_r
    Moderator
    Posted 16 years ago #

    Same way - go into phpmyadmin, search for domain name, replace in every field.

About this Topic