close

Slick­Stack

July 2024 promo! Join our Discord free of charge.

Slick­Stack
Lightning-fast WordPress on Nginx

easiest way to convert WordPress Multisite Network to single site?

  • This topic is empty.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #24982 Reply
    Peter
    Guest

    without using premium plugins or something, what is the easy way ?

    #24984 Reply
    Willie
    Guest

    I think All-in-one Migration can export a subsite and then import to single site but yah, pretty sure that is a premium add-on.

    #24986 Reply
    Joseph
    Guest

    without using premium plugins or something, what is the easy way ?

    It depends slightly on whether you want to export the “main” site in the Multisite network or a different subsite. If the main site, it’s a bit simpler. Because the media uploads are probably already correct i.e. in the correct folders like /uploads/2024/ instead of /uploads/sites/3/... or whatever.

    If the media files are NOT correct, you should copy and paste the media uploads from the given subdirectory under /sites/ and into the normal directories as mentioned.

    After that, remove any Multisite rules in your wp-config.php

    After that, delete any tables in MySQL that are only for Multisite like:

    wp_blogs
    wp_blog_versions
    wp_registration_log
    wp_signups
    wp_site
    wp_sitemeta
    wp_sitecategories (only, if exist)

    See: https://wordpress.stackexchange.com/questions/30103/convert-a-multisite-wordpress-install-into-a-single-site

    #24987 Reply
    Joe
    Guest

    After your media uploads are correct, and your wp-config.php is correct (all settings for Multisite are removed in that file) so the last step is ensuring that your remaining WordPress user(s) have Administrator permissions in the single site.

    You can run wp user list using WP-CLI to get a list of current users.

    Then, run wp user set-role 1 administrator (change 1 to be the correct ID number of the user you want to change).

    After that you can clear all caches as needed and refresh the site.

    Helpful: https://gridpane.com/kb/how-to-reset-wordpress-user-roles-with-wp-cli/

    #24988 Reply
    Juan
    Guest

    Some of your plugins might be disabled during this process so just visit the Plugins page in WP Admin and reactivate plugins if necessary.

    Also if you need to search/replace URLs in the database you can use WP-CLI:

    wp search-replace https://oldsite.example.com https://example.com --all-tables

    #25030 Reply
    Jose
    Guest

    just curious, is there a way to automate this in a script?

Viewing 6 posts - 1 through 6 (of 6 total)
Reply To: easiest way to convert WordPress Multisite Network to single site?

Thanks to our generous sponsors for their support!