Remove WordPress Multisite data

Lots of articles are written across the web about how one can use WordPress Multisite capabilities to power several blogs from one installation. This feature comes from WPMU being merged into WP. Recently I was working with a client, which was stucked in between of the process of setting up and wanted me to complete it.

Removing WordPress Multisite data was a new subject and Google search gave nothing useful, so I am sharing on how you can remove WordPress Multisite data completely incase you don't want it or you want to re-install with a fresh state or whatever.

Before proceeding make sure you take a backup of the database so you can restore it if something goes wrong. And if you don't feel comfortable or don't really know what you are doing, then you shouldn't be doing it. Get a developer to do this for you.

  • Remove all the lines added to wp-config.php
  • Revert back to older .htaccess file or delete it and regenrate it by going to Settings > Permalinks
  • Remove the two fields added to the users table that are multisite-only (deleted and spam columns).
  • Remove the following tables in database (prefixed by your DB prefix which is generally wp_):
    • wp_blogs
    • wp_blog_versions
    • wp_registration_log
    • wp_site
    • wp_sitemeta
    • wp_signups
    • wp_sitecategories (if you have global terms enabled)

Now you have a clean WordPress install without any trace of Multisite data. Let me know if you have any questions :)

About Ashfame

Developer + Entrepreneur + Opensource fanatic. Love WordPress + Startups + Music + Adrenaline kick.

  • Zac

    Thanks for doing this. It’s a dumb question – but I have to reinstall the multi-site and I don’t really understand where to find these tables! I’m going nuts here. Any help would be really appreciated.

    ZB

    • http://www.ashfame.com/ Ashfame

      You can use phpMyAdmin to do that

  • Zac

    Thanks again. This was super helpful.

    • http://www.ashfame.com/ Ashfame

      Glad that you found it useful :)

  • http://nickthrolson.com Nick Throlson

    Thanks for this I had big issue with my main site thinking it was a multi site when trying to upgrade had problems it auto creating new db tables hope this fixes it.

  • http://www.stupidnothings.com Edwin

    Unfortunately, after deleting the .htaccess file I’m getting errors.

    Fatal error: Call to undefined function wp() in /home/bookieb/public_html/stupidnothings.com/wp-blog-header.php on line 14

    and

    Fatal error: Call to undefined function get_option() in /home/bookieb/public_html/stupidnothings.com/wp-admin/admin.php on line 22

    • http://www.ashfame.com/ Ashfame

      Hi Edwin,

      These errors don’t seem to relate with .htaccess file
      Did you regenerate the permalinks from Settings > Permalinks?

  • Pingback: Remove WordPress Multisite data « Ryo's todo list

  • http://www.kyleandrach.com Kyle Morgan

    Thank you so much for this info! I broke a lot of stuff when I turned this on for my site, I couldn’t figure out how to get everything working in wordpress again until I found this!

    • http://www.ashfame.com/ Ashfame

      Happy to help :)

  • http://chodak.com Miroslav

    Brilliant! Worked like a charm. Thanks for the tutorial!

    • http://www.ashfame.com/ Ashfame

      Glad to help :)

  • Larry K

    You may also need to deal with images depending on the multi-site install.

    If your .htaccess included
    #RewriteRule ^(.*/)?files/(.*) wp-includes/ms-files.php?file=$2 [L]

    Then change it to:
    RewriteRule ^(.*/)?files/(.*) wp-content/uploads/$2 [L]

    You will also need to copy over the files from the files dir to the usual content/uploads dir.
    And change the upload dir setting in Media Settings in the admin panel.

    I also had a problem that the blog’s tables were wp_1_xxx but the user table was wp_user.
    Fix:
    a) rename wp_user to wp_1_user
    b) change db prefix in wp-config.php to be wp_1_

    • http://www.ashfame.com/ Ashfame

      Its better to regenerate the .htaccess file then editing it. Not sure about the uploads setting (may be you are right), and your others steps are more of like keeping one of the blog as the primary blog and removing others, else you won’t need to do that. User tables are shared across a multisite install.

  • http://www.affiliatetechsupport.com Stian

    Great post, finally got rid of that WPMU install! Alot better than what you find on the wordpress.com forums ;)

    • http://www.ashfame.com/ Ashfame

      Haha thanks, I have never dealt with WPMU. Glad that the post helped you.

  • http://theinternetmoneyguide.com Tara

    Thank You So Much I Have Been Trying To Find A Way To Go Back To A Regular WP Account For A While Now!

  • http://theinternetmoneyguide.com Tara

    Thank You!! I have tried to find a way to do this for some time. I have found a lot of people are looking for this but only just today I found this site! Aloha to you!!

  • Jairo Lopez

    THANKS. I was very concerned on how to go back.

  • http://dailynabil.com Nabil

    Thanks man!

  • silentprincess

    Hi,

    Please help. When I removed those tables I get this error when I access the website: Error establishing database connection.

    thank you!

  • http://reliefme.ca Joseph

    Fantastic, worked perfectly for me.

    Thanks for the write-up; This kind of information should be on the official WP website, along with installing the network.

  • http://www.techmoment.net/ Mohamad

    Thank you very much!

  • joe

    Well thanks…. Lost every bit of information in my blog following your instructions.

    • http://www.ashfame.com/ Ashfame

      You do realize you did something wrong in following the instructions, right? This post was for developers and not end users. Do you have a recent backup to restore it? If not, ask your webhost if they have one.

  • Cozza

    Thank you so much for this! Worked like a charm.

  • gotchi

    First of all, thank you for posting this.

    I am new to using wordpress and I wanted to see what Multi-site was like for a bit but I realized this isn’t for me yet. I installed multi-site a year ago but never really used it so I’m wiping everything out and starting afresh. I want to make sure I’ve properly uninstalled this in case of future complications with other plug-ins and so on.

    I managed to get through Steps 1-2 but I can’t seem to get through Steps 3 and 4.

    3) I wasn’t able to locate ‘deleted/spam’ columns cos I don’t know where the user table is. Is this located within my WordPress dashboard? I do not see any new user tables in my FTP database either

    4) Also could not locate any of the listed tables in my FTP. I don’t see anything with wp_.

    Overall, I know in my wordpress dashboard, the subdirectory i had created from multi-site is gone (as in, I don’t see the option to visit my other site). I do not see the extra user under Users either. Under Settings the ‘Enable multi-site’ option is still there but it gives me the initial introduction to the “Network installation process” which I recall when I first installed Multi-site. since this option is there, it doesn’t seem like I’ve uninstalled Multi-site right?

    Help would be appreciated.

    Thank you in advance.

  • http://lemesos-blog.com savvar

    thnx very useful

  • http://amitshrikulkarni.in ASK

    Hi,

    I followed every step in the tutorial. But now I cannot see my site’s dashboard. When I log in i can see only profile page no other tabs are available. Any idea where I went wrong in removing the multisite feature?

  • http://osxstory.com OS X Story

    Hello, thanks it’s work for me.

  • http://www.miabakeca.com Fazio

    Hi,
    i did everything right, but have the same problem as ASK : “I cannot see my site’s dashboard. When I log in i can see only profile page no other tabs are available.”

    May you help me please?

    Thank you.

  • http://www.blowupbhangra.com kamal

    you may also require a single site wp_config file (original) otherwise your site will end up in a singup loop, i panicked at first seeing The webpage at http://yourdomain.com/wp-signup.php?new=yourdomain.com has resulted in too many redirects.

    its because there are lines of code in the wp_config file that refer to MU.

    Thanks for the help.

  • http://islam-muslim.net Islam Muslim

    i am done all the step but when i do this my site registration don’t sent mail why?
    now i can restor my site but i still need to remove multisite. please help

  • Mieren

    Thanks!! You saved my bacon!