Migrating WP MultiSite Setup from one domain to another

  • Resolved shoaibi

    (@shoaibi)


    12 years, 9 months ago

    I have migrated my wordpress(with network sites enabled) to another domain, changed domain in wp-config.php and change the domain column for the only blog in wp_blogs table in db to the new domain. Problem is i don’t see Network Menu anymore when i click my username.

    If i delete everything else besides:
    define('WP_ALLOW_MULTISITE', true);
    and click on network setup, it says that the network is already setup, still i repaste the shown instructions in wp-config.php[after deleting previous] and .htaccess, but no use.

    PS:
    I also changed my username from “a” to webmaster in db during the process, changed it everywhere.

Viewing 12 replies - 1 through 12 (of 12 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 9 months ago

    Did you also edit your .htaccess?

    You also need to search your WHOLE database for all instances of olddomain and replace it with newdomain.

    Andrea Rennick

    (@andrea_r)

    12 years, 9 months ago

    I also changed my username from “a” to webmaster in db during the process, changed it everywhere.

    then you also knocked yourself off as a super admin.

    Thread Starter shoaibi

    (@shoaibi)

    12 years, 9 months ago

    @ipstenu: already did that.

    @andrea_r: Hmmm, and how would i fix that? changing username back to admin? or is there another solution.

    I might be repeating myself but i change username and domain throughout the database and grep on the db files shows 0 records for old user or domain.

    Andrea Rennick

    (@andrea_r)

    12 years, 9 months ago

    Go look in the db in the… uh… usermeta table. there’s a record there that saves the super admin’s username.

    Or, change your name back to admin, make a new user with the username you want, promote them to super admin as well, then just… leave the admin username with a superhard password.

    I know some security tips say remove that user, but I’ve also seen people sign up with the admin username if it didn’t exist. 😉

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 9 months ago

    change the domain column for the only blog in wp_blogs table in db to the new domain.

    You only said you did the wp_blogs so … Being careful 🙂

    Go into wp_sitemeta

    Look for the meta_key for site_admins and make sure your NAME is there.

    (ETA: Andrea, I just looked in usermeta and can’t find it there… Elf needs more coffee, though)

    Thread Starter shoaibi

    (@shoaibi)

    12 years, 9 months ago

    my wp_sitemeta contains
    8 1 site_admins a:1:{i:0;s:1:”webmaster”;}

    while wp_users has:
    1 webmaster $P$BT5BVrX0G9fJldLX/chVt2ZfcbZDKc0 webmaster …….

    but still doesn’t work.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 9 months ago

    Dang it, there;s another place that I’m not thinking of … Was the old user name really just ‘a’ or was it ‘admin’?

    You MIGHT be able to search the whole db for “a” (in quotes) …

    Andrea Rennick

    (@andrea_r)

    12 years, 9 months ago

    :{i:0;s:1:”webmaster”;}

    See the s:1? that’s wrong. s is the character count of the word in quotes.

    Thread Starter shoaibi

    (@shoaibi)

    12 years, 9 months ago

    It was just ‘a’ and searching for “a” turns 0 results.
    I am gonna take a dump of db and then change all webmaster back to ‘a’ to see if it works. If it does i will ask you people for a proper way to create a new super administrator and disable ‘a’.

    Thread Starter shoaibi

    (@shoaibi)

    12 years, 9 months ago

    @andrea_r
    and bullz eye, that was the issue. Thanks a lot, really appreciate your help.

    @Iptenu, thanks 🙂

    Andrea Rennick

    (@andrea_r)

    12 years, 9 months ago

    oh computers.. so picky at being specific. 😀

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    12 years, 9 months ago

    Oh dang, I forgot it counted words! Silly computers!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Migrating WP MultiSite Setup from one domain to another’ is closed to new replies.