Marinus Klasen

Marinus Klasen

  • Development
  • Consultancy
  • Developer Resources
  • Blog
  • Contact

March 25, 2021

Moving a multisite: Database errors & site not found.

Marinus Klasen

Moving a multisite doesn’t always go with the ease you expect. I usually do this in two steps:

  1. Export the database
  2. Deploy/copy/sync the files to my new (staging) server

When your files are ready and your new environment is configured it’s time to import the database. My preference goes to using WP-CLI for this. Copy over the database and run wp db import ~/_sql/database-export.sql.

When you’re moving/copying to a different domain, you also have to run database replacement scripts:

wp search-replace "https://olddomain.com" "https://newdomain.staging.com" --all-tables
And repeat this for your other subsites:
wp search-replace "https://sub.olddomain.com" "https://sub.newdomain.staging.com" --all-tables

Then it’s time to load your website, and you’re presented with a big fat:

Error establishing a database connection

Also, the wp-cli commands fail to run, showing errors like: Error: Site ‘newdomain.staging.com’ not found. Verify DOMAIN_CURRENT_SITE matches an existing site or use --url=<url> to override.

Right.. so, there’s still something in the database that is not replaced.. You’ll find out when running: `wp db query “SELECT * FROM wp_blogs”`

This clearly shows that the domains of these sites are not replaced, because they don’t include https, so let’s run the command below to confirm the fix:

wp search-replace olddomain.com newdomain.staging.com wp_blogs --dry-run

Happy with the output? Then let’s run it without –dry-run:

The fix

wp search-replace olddomain.com newdomain.staging.com wp_blogs

About Marinus Klasen

Marinus has been working in software/web development for more than a decade. Since 2020 his attention shifted on sharing knowledge and developing products and tools for sharing knowledge.

Marinus Klasen on Twitter

This site runs on Cloudways.
It's fast isn't it?
Cloudways offers high-quality, fast and affordable hosting.

Learn more

Need a hand? Post your project and hire me and other top notch developers on Codeable.

Hire me on Codeable

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Ready to take action?

I'm looking forward to discuss your projects and goals!
Feel free to reach out using the contact details below.

Marinus Klasen

[email protected]
twitter.com/marinusklasen
linkedin.com/in/marinusklasen

  • GitHub
  • LinkedIn
  • Twitter

Have you read?

  • Storing private data with SSH on WPEngine sitesDecember 15, 2022
  • Get the HTML content of a block edit page or post in WordPressNovember 30, 2022
  • Rename Coupon code text to Discount code in WoocommerceNovember 3, 2022
  • Background-size cover in mPDFOctober 22, 2022
  • WordPress.com SSH & duplicating a WordPress.com website locallyOctober 11, 2022

Copyright © 2023 · Marinus Klasen | Webdesign by Team Rood