Detach site from multisite (turn off multisite)

I’d just export all content from the site you want to keep. Then create a new WP instance, import that exported data, tweak as required.

Once the site is OK, make the new site active for the desired domain name (in your hosting, point the domain to the new site’s folder). No messing with databases required.

Added 31 July 2020

Another way: Use the Clone plugin from Automatic to export subsite. Install the plugin as superadmin. Then admin to the subsite and use the Clone plugin to back up everything.

Create a new WP instance (single-site), then install the Clone plugin there. Then import the backup you made of the subsite into the new site via the plugin. Make sure you remember the admin credentials, as everything on the new site will be replaced during the restore process.

Everything from subsite will now be on the new site including themes, plugins, settings and content.

Related Posts:

  1. Site Redirecting to wp-signup.php
  2. How to migrate subsite from dev multisite to production multisite
  3. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  4. Transfer Subdomain site to Multisite setup
  5. Which is the recommended method to transfer a wordpress site to wordpress Multisite?
  6. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  7. Move a WordPress multisite to subfolder (the whole site)?
  8. Migrating WPMS from apache to IIS7 causes Database Error
  9. Copy site from one multisite to another
  10. How to change a WordPress network domain
  11. Trying to migrate a WordPress Multisite with Domain Mapping
  12. Issue converting single site to multi-site – blogs.dir folder not created
  13. How to Move Local Singlesite Database to Remote Multsite Database?
  14. What is the best practice to get a site from local to online?
  15. What should I do? A multisite, a single website or many websites? [closed]
  16. WordPress mutisite migration
  17. Migrate a WP website from a single-server single-domain to a multi-server multi-domain installation
  18. Migrating Multisite – Database error, missing wp_blogs table
  19. Moving WordPress Multisite
  20. Redirect only posts to New Domain
  21. Migrating wordpress multisite and domain mapping plugin
  22. How to convert multi-site to single site
  23. How to move 1 WP site from a mult-site environment to a different multi-site area
  24. Adding a existing developed site to a multisite installation of WordPress
  25. new multisite, old db
  26. how to migrate wpmu from one host to the other?
  27. Migrating Multisite with WP-Cli and/or Search-Replace-DB
  28. Migrating wordpress sites through localhost and ubuntu
  29. Migrating Multisite setup to a different domain
  30. Migration: previous URL redirection after migrating
  31. how to convert a wp multisite into a single site with content from subsites
  32. After switch domain, some parts of my site still point to my old domain
  33. How to migrate post media from stand-alone to multisite build
  34. local wordpress multisite not working on AWS development server “error establishing database connection”
  35. WordPress Multisite keeps redirecting to HTTPS
  36. Migrating a WP site with 2 WP installations
  37. Multisite network on new domain
  38. Moving wordpress multisite to new domain
  39. Assign user to belong to a subsite in Multisite instance
  40. Send data from one WP instance to another and process it there
  41. Migration of Multisite WordPress site from http to https
  42. After cloning my WordPress database to another server, I cannot log in
  43. Export to WXR for pages containing script and iframe tags
  44. Moved my site to new host now getting 404
  45. How to install wpengine hosted multisite locally
  46. How do I make a copy of WordPress to other folder
  47. Post migration from one site to another site in a network
  48. Moving a primary domain to another host as secondary cause errors in some image URL
  49. Moving a WordPress Multisite site to a new install
  50. How to use WordPress Multisite With Different Domain Names?
  51. How To Add Custom Form Fields To The User Profile Page?
  52. Where are available Roles Defined in the wp_ database?
  53. restore_current_blog() vs switch_to_blog()
  54. Can i merge 2 new WP_Query($variable) ‘s?
  55. How to disable a network enabled plugin for just one site?
  56. How to reliably flush rewrite rules on multisite?
  57. Moving a WP Multisite to a subdirectory
  58. Cookies in multisite where network sites have their own domain name
  59. Convert a Multisite WordPress install into a Single site
  60. WordPress MultiSite Active Directory integration and site privacy
  61. WordPress Job Interview Preparation
  62. How to add Custom Blog Options to new blog setup form?
  63. How can I trust switch_to_blog()?
  64. Remove the blog slug from WordPress Multisite root node
  65. Why are my roles not visible in a Multi-site/Network?
  66. Site admin in a network install can’t edit users?
  67. How to use same email for multiple users
  68. How to run an activation function when plugin is network activated on multisite?
  69. Specific upload folder for PDFs in custom Post type in WP multisite
  70. What is the correct way to map multiple domains in a WordPress 4.1 multisite install?
  71. Where can I find documentation on what characters are allowed in user names and why?
  72. How can I un-reserve a pending username registration?
  73. How do I remove/delete an old super admin user?
  74. DB connection error after copying a WordPress Multisite instance to a second location
  75. Redirect Main Site to Subsite in Multisite WordPress
  76. Is there a is_user_logged_in() for multisite?
  77. Switching MultiSite installation from HTTP to HTTPS
  78. Allow user to select a theme to install when they signup
  79. Setting up a wordpress network with third level domains
  80. Get upload URL by blog ID in multisite
  81. What’s the difference between get_site_option and get_blog_option?
  82. Need help sorting “My Sites” Alphabetically
  83. How to delete post revisions?
  84. Create mobile site with same content just different theme
  85. Add additional Network constants to wp-config.php dynamically
  86. Multisite stuck at 1MB for max file size
  87. How to get blog name, when using WordPress Multisite
  88. What are options are there to implement a multi language site
  89. Switching primary site in WordPress Multisite
  90. Multisite Network Port Num Issues?
  91. Convert existing site to network
  92. Where is the robots.txt stored for a WordPress Multisite install?
  93. Settings API in Multisite – Missing update message
  94. Add WordPress MU Network Admin via Database
  95. How to get current site id? (WPMU)
  96. Multisite on Windows with wildcard subdomains
  97. Why is WordPress Multisite redirecting to wp-signup.php and how to fix it?
  98. Which asset URLs are acceptable in a “vanilla” MU install?
  99. $wpdb->base_prefix not get parent site prefix in multisite
  100. How to tell which database tables belongs to which multisite site
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)