change database to multisite in localhost

So just to clarify, you’ve already setup the multisite by following:
https://codex.wordpress.org/Create_A_Network

And the multisite is working and you can create subdomains. But you want your current site to be a subdomain?

If so, I think the best way to do this will be to create the new sub site first, then use a cloning/migration plugin to copy all your data from your current site to the new sub site. WordPress has it’s own export-import plugin:

https://en-gb.wordpress.org/plugins/wordpress-importer/

The WordPress Importer will import the following content from a WordPress export file:

  • Posts, pages and other custom post types
  • Comments
  • Custom fields and post meta (this will include your post thumbnails and attachments).
  • Categories, tags and terms from custom taxonomies
  • Authors

Then you can remove all the data on your root site.

There are other cloning/migration plugins if you don’t like the WordPress importer.

Related Posts:

  1. How to use WordPress Multisite With Different Domain Names?
  2. How To Add Custom Form Fields To The User Profile Page?
  3. Where are available Roles Defined in the wp_ database?
  4. restore_current_blog() vs switch_to_blog()
  5. Can i merge 2 new WP_Query($variable) ‘s?
  6. How to disable a network enabled plugin for just one site?
  7. How to reliably flush rewrite rules on multisite?
  8. Site Redirecting to wp-signup.php
  9. Moving a WP Multisite to a subdirectory
  10. Cookies in multisite where network sites have their own domain name
  11. Convert a Multisite WordPress install into a Single site
  12. WordPress MultiSite Active Directory integration and site privacy
  13. WordPress Job Interview Preparation
  14. How to add Custom Blog Options to new blog setup form?
  15. How can I trust switch_to_blog()?
  16. Remove the blog slug from WordPress Multisite root node
  17. Why are my roles not visible in a Multi-site/Network?
  18. Site admin in a network install can’t edit users?
  19. How to use same email for multiple users
  20. How to run an activation function when plugin is network activated on multisite?
  21. Specific upload folder for PDFs in custom Post type in WP multisite
  22. What is the correct way to map multiple domains in a WordPress 4.1 multisite install?
  23. Where can I find documentation on what characters are allowed in user names and why?
  24. How to migrate subsite from dev multisite to production multisite
  25. How can I un-reserve a pending username registration?
  26. How do I remove/delete an old super admin user?
  27. DB connection error after copying a WordPress Multisite instance to a second location
  28. Redirect Main Site to Subsite in Multisite WordPress
  29. Is there a is_user_logged_in() for multisite?
  30. Switching MultiSite installation from HTTP to HTTPS
  31. Allow user to select a theme to install when they signup
  32. Setting up a wordpress network with third level domains
  33. Get upload URL by blog ID in multisite
  34. What’s the difference between get_site_option and get_blog_option?
  35. Need help sorting “My Sites” Alphabetically
  36. How to delete post revisions?
  37. Create mobile site with same content just different theme
  38. Add additional Network constants to wp-config.php dynamically
  39. Multisite stuck at 1MB for max file size
  40. How to get blog name, when using WordPress Multisite
  41. What are options are there to implement a multi language site
  42. Switching primary site in WordPress Multisite
  43. Multisite Network Port Num Issues?
  44. Convert existing site to network
  45. Where is the robots.txt stored for a WordPress Multisite install?
  46. Settings API in Multisite – Missing update message
  47. Add WordPress MU Network Admin via Database
  48. How to get current site id? (WPMU)
  49. Multisite on Windows with wildcard subdomains
  50. Why is WordPress Multisite redirecting to wp-signup.php and how to fix it?
  51. Which asset URLs are acceptable in a “vanilla” MU install?
  52. $wpdb->base_prefix not get parent site prefix in multisite
  53. How to tell which database tables belongs to which multisite site
  54. what are pmxi tables? [closed]
  55. Using wp_insert_post() with Networking enabled
  56. Are nested subdomains possible with a subdomain multisite?
  57. Sharing Dynamic Sidebars across Multisite Blogs
  58. I want to develop locally with Multisite, then migrate each site to separate remote WP installs
  59. Password Reset for Users on a Multisite Subsite
  60. Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
  61. Can a multisite’s blogs be accessible from two different sub-domains?
  62. Querying posts from multiple sites in a network?
  63. Plugin for editing options on multisite?
  64. What do I need to do to convert my MultiSite from HTTP to HTTPS?
  65. is_front_page() malfunction?
  66. WP Multisite development with Mamp Pro and wildcard subdomains, not really working for me
  67. How to share WordPress core library
  68. How do I change the Multisite URL?
  69. Create site programmatically for WPMU
  70. Can upload doc and pdf but not ppt – not permitted for security reasons
  71. How Can I Centralize Content Usage and Approval in a WordPress Multi-Site installation
  72. WordPress Multisite: Adding actions to only one site
  73. WordPress Multisite allow site admin to add user without email confirmation
  74. Domain mapping (without plugin) in 4.5.x multisite?
  75. wordpress multisite, how to keep user on subdomain throughout registration process?
  76. How will self-hosted WordPress work with Google Page Speed Service?
  77. WordPress Multisite, NGINX and WordPress Subdirectory Install
  78. Multisite Domain Mapping with SSL
  79. get_user_meta() to Return User Meta Only for Current Blog in Multi Site
  80. Basic Multisite Question – Managing Content Centrally
  81. Can I set some default pages to be created on every creation of a new blog
  82. Customizing wp-activate.php
  83. Listing of all uploaded files in network sites
  84. Troubleshooting a “You do not have sufficient permissions to access this page” error
  85. Network not displaying all sites and users
  86. WordPress Multisite – When a user signs-up on main site, how to add the user to a subsite
  87. create /blog subsite on WordPress multisite
  88. multisite 404 error for subdirectory
  89. How to hide or remove unwanted widgets on Multisite installation?
  90. WordPress Multisite Multiple child theme
  91. Use wp_nav_menu() to display a Menu from another site in a Network install?
  92. How to Control user registrations directly on sub-sites
  93. multisite: use a virtual subfolder for subblogs
  94. How to set an option for all sites in my network?
  95. How to set up wordpress domain mapping on MAMP Pro
  96. How to hide admin account in BuddyPress? (for security reasons)
  97. How do I transition multiple installations to a single Multisite installation?
  98. How to use alias domain for multisite installation?
  99. Multisite htaccess on localhost with WP as an SVN external?
  100. WordPress Multisite: How to make all media library items available for every site?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)