Moving WordPress Multisite

The problem is you ran an SQL query to change the site name. Doing this mangled and corrupted values that were serialised by PHP

Instead, use a Search replace script that will grab the values, deserialise, replace then re-serialise. WP CLI has such a command.

The reason for this is that the PHP serialised values contain the length of the URL, and by doing an SQL search replace, they are no longer valid. This breaks WordPress, leading to the problem you have. For this reason, an SQL query in an SQL client will never work.

Since you’ve already done this once on your database, you will need to undo the initial damage before you can run a search replace command via WP CLI

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. Redirect only posts to New Domain
  20. Migrating wordpress multisite and domain mapping plugin
  21. How to convert multi-site to single site
  22. How to move 1 WP site from a mult-site environment to a different multi-site area
  23. Adding a existing developed site to a multisite installation of WordPress
  24. new multisite, old db
  25. how to migrate wpmu from one host to the other?
  26. Migrating Multisite with WP-Cli and/or Search-Replace-DB
  27. Detach site from multisite (turn off multisite)
  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. What are options are there to implement a multi language site
  51. Where is the robots.txt stored for a WordPress Multisite install?
  52. Settings API in Multisite – Missing update message
  53. WordPress Multisite Multiple child theme
  54. WordPress Multisite. Can domain be used instead of subdomain?
  55. Built to scale, or worry later?
  56. Multisite Subdomains result in 403 Forbidden
  57. Set subdomains live in a next step
  58. Should multi-language site using multi-site architecture have default language in base site?
  59. Multisite Installation: how do I setup global search?
  60. Register email as username
  61. Help with updating a wp_get_sites to get_sites and sorting by alphebetical order
  62. Multisite Subdomain Using More Resources Than Others?
  63. Can I use multisite functions in a single-site installation?
  64. WordPress multisite change language
  65. Multisite, multiple domains per site
  66. delete_user_meta : how to delete all the metadata of a given user (witout SQL)
  67. Within the database, where is the flag which says that a user has Super Admin rights?
  68. Switch a single site to a multi-site
  69. Preferred method of setting user role only works on Main Site in Network
  70. Multisite sub-directories IIS 7.5 change media/uploads location
  71. One Domain, Two Installs of WordPress
  72. add_rewrite_rule not working in WordPress Multisite
  73. How do I find where the current value of the option ‘registration’ in the SQL database?
  74. Strange multisite issue where all sites return same id with get_current_site()
  75. Creating a subdomain network in a subdomain
  76. Sub-sub folders of WordPress Multisite subdirectory
  77. Allow editors to switch sites (Multisite)
  78. How much resources are good enough for 3.9.2
  79. Best Practise: Linking to WPMU sites from other sites
  80. Common user login for two different wordpress installation and bbpress
  81. Trouble with SQL SELECT inside switch_to_blog()
  82. WordPress Multisite and how to apply sef urls only to specific sites
  83. Custom css – WordPress Multisite
  84. “Multisite support is not enabled.” After Multisite Config Changes
  85. String translation within WordPress multisite with i18n not working on all sites
  86. Add new sites on the same level as the parent URL in a multisite
  87. Search returns “Nothing Found” on a sub directory
  88. Add radio button on theme at the select of the theme the same theme should be activated after generation of new site in multi site
  89. Users getting linked unwanted to main mu in WordPress multisite (WPMU)
  90. Changed singlesite to multisite, but new site shows Maintenance
  91. multisite shared settings
  92. Multi Site Translate Strings
  93. Responsive Wordress Site – Serve different post types to each device
  94. Should I use MultiSite for a subdomain based wp site?
  95. Admin user getting redirected to /wp-admin/user
  96. Is there a way to have wordpress 301 versus 302 urls by default?
  97. Some Subdomains on a Multisite Install Not Found
  98. personal_options hook on WordPress multisite
  99. Multi site root site installed on subdomain, with child sites as subdirectories
  100. Integrating WordPress for blog and other content pages in a web app