moving tables between multisite installs

For WP multisite these are the main site (ID=1) database tables:

wp_commentmeta
wp_comments
wp_links
wp_options
wp_postmeta
wp_posts
wp_term_relationships
wp_term_taxonomy
wp_terms

Related Posts:

  1. restore_current_blog() vs switch_to_blog()
  2. Which asset URLs are acceptable in a “vanilla” MU install?
  3. Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
  4. What do I need to do to convert my MultiSite from HTTP to HTTPS?
  5. Using MAMP and Xip.io to view a WordPress Multisite on a local network
  6. REST API for Multisite
  7. How can I display all Multisite blogs where this user is administrator?
  8. Multisite: use media from one site vs. copying the same media to all language sites?
  9. Create unique robots.txt for every site on multisite-installation
  10. WPDB Multiple site’s posts and get featured images
  11. Using WP CLI to set options in WP Multisite
  12. “Upgrade Network” error: stuck with SSL certificate verification
  13. Ideal WP multisite server setup for up to 1000 sites?
  14. Restrict the user access in multi site for non-assigned blogs
  15. Getting an ERROR: Cookies are blocked error when logging in to a site on a different domain?
  16. display merged posts from multisite and sort by latest date
  17. WordPress 3.2(Multisite) – How to add custom user meta fields to signup form?
  18. WordPress 3.8.1 Multisite blog slug problem
  19. Transients API and multisite
  20. WordPress Multisite – Multiple Subdirectories
  21. Images uploading to wrong directory after changing to multisite
  22. Why are images uploaded to main domain, when using multisite with different domains?
  23. Subdomain login problems
  24. Importing Multiple DB to one MU database
  25. How to Redirect login User with Mapped Domiain Primary blog Url to Original Sub-site Url
  26. Determining the compatibility of Settings API & Multisite
  27. Downgrading a WP3.3.1 Network Install
  28. WP Multisite – domain mapping to domain.com and separate site to domain.com/help
  29. Update User Role Across Network when Main Site User is Updated
  30. Shared User Tables on 2 WordPress Sites; “Main” Site and “Discuss” using P2?
  31. Create custom role, multisite, add users/sites?
  32. https redirect hell (adding www)
  33. How to disable W3 Total Cache “Performance” menu under multisite? [closed]
  34. How i can get blog info using site url in multi-site
  35. Embedding screencast.com Videos in WordPress Multisite
  36. Will revisions be retained when converting to a multi-site?
  37. How to create sub site in wordpress multisite programmatically?
  38. Multisite on localhost using xampp
  39. wp-config dynamic hostname in WP_HOME and WP_SITEURL
  40. Include only a domain path in multisite Network
  41. Jetpack API for WordPress Network
  42. WP doesn’t remove uploads from folder when removed from “Media Library”?
  43. How does WordPress determine which multisite the user is on from the URL?
  44. Multiple multisite instances connecting to the same database
  45. Multisite multidomain
  46. How can I use WP_Site_Query to find a blog by blog name?
  47. Limit entries number on network/sites.php
  48. Single sign on for several website domains
  49. Multi-language site on different domains
  50. How can I use separate domains for single pages?
  51. SEO implications of assigning a new domain to a multisite subdomain [closed]
  52. How can I add custom meta on signup page and pass along to be used after blog activation?
  53. Conditional Image Sizes for Use via Theme Customizer Upload Only
  54. How to check main blog in a multisite using if statement?
  55. Create default pages in wordpress multisite
  56. Is there is a way to group a large number of WordPress Multisites For Easier Organisation?
  57. Multisite on single wordpress
  58. Why are “numeric only” names disallowed when creating a new site in a WordPress multisite network?
  59. How to organize my js files
  60. Installing multisite network on a bluehost addon domain
  61. How to delete users from a WordPress MultiSite that stay in the DB?
  62. Update WP install to WP network & it broke the DB connection
  63. Installing other applications alongside WordPress multisite and configuring dns routing
  64. All Network sites display as main blog
  65. How can you customize on a multisite?
  66. Is a multisite install what I need?
  67. Infamous admin login redirect
  68. Running hundreds of WP in multisite
  69. Manually Moving Posts/Pages/Comments/Tags from WPMU to WP3.0
  70. Create link preview for theme wordpress
  71. Bitnami multisite change URL of secondary blog
  72. Language per user role, how can I achieve this?
  73. Internet explorer not finding right content from multisite
  74. Change WordPress multisite to sub-folder installation
  75. Number of total comment does not tally with the number of comment?
  76. Domain not redirected correctly with WordPress Multisite
  77. How to add a link of “one” website in posts of “second” website in multisite WordPress
  78. Themes are visible in Network, but invisible in sites
  79. No debug log for WP multisite is created
  80. WordPress theme to support single website but with 3 sections for 3 languages
  81. Can assign a new domain to a site in a multisite?
  82. Possible to have duplicate usernames on different two multisites
  83. Main site media are accessible in subsite domain
  84. Multisite – each site with it’s own set of users
  85. Including non-wordpress pages within a single multisite domain
  86. How can I import posts into different wordpress multisites at once?
  87. Redirect www.mainsite.com/subsite/wp-login to www.mainsite.com/wp-login
  88. Activation of new Registered site fails on multisite
  89. Migrate site from WordPress multisite to another WordPress multisite
  90. How to login a user with wp_set_auth_cookie on a specific blog within a multisite environment
  91. Split a Multisite Into Single WordPress Websites
  92. How does adding custom meta to signup form work?
  93. Can’t un-archive site after upgrading to WordPress 3.8
  94. How to handle responsive and non responsive websites in one WordPress Theme?
  95. Is it possible to put a site other than #1 as a Multisite top-level domain?
  96. Should I go for Multisite or separate WP Installation?
  97. Swap domains of two sites with each other in multisite
  98. Many big issues in the website, WP_Debug not showing
  99. Change a subsite Admin role of a WordPress Multisite after 24 hours registering
  100. different image for mobile template block theme