Problem Description: When attempting to import the site from MyKinsta to DevKinsta, the process fails. The site is inaccessible, attempting to redirect to http://undefined. Additionally, the wp-admin area displays a database connection error. The live site on MyKinsta remains fully functional.
Error Message Received:
“Error establishing a database connection. Could not find site sitename.local:[port]. Searched for table wp_blogs in database SiteName_redacted.”
Troubleshooting Steps Performed (No resolution):
Re-imports: Performed multiple fresh imports (Single domain, Subdomain Multisite, and Directory Multisite configurations).
SSL/HTTPS: Toggled SSL settings on and off within DevKinsta.
Environment Variables: Attempted manual adjustment of environment variables.
Config Files: Verified wp-config.php definitions for WP_HOME and WP_SITEURL.
Database Check: Confirmed access to the database manager is possible, but the site remains unable to connect to the specific required tables.
Request: The user requires assistance resolving the import failure for this specific multisite configuration. Previous attempts at self-troubleshooting and standard re-installation have not corrected the database mapping or the redirect loop. Please investigate why the multisite import process is failing to correctly map tables for this environment.
Based on the database connection error you shared, it appears that the Pull action was unable to correctly update the domain entry in the wp_blogs and/or wp_site database tables. This issue may arise due to the configuration of WP Multisite. So a manual database update is needed when doing Push/Pull actions. Could you please review these two tables in DevKinsta to ensure the .local domain is properly set?
Based on the above error, it seems that the domain entries in the wp_blogs and/or wp_site database tables in DevKinsta were not updated from: “redacted_domain.com” to “sitename.local” during the Pull site action. Please check this two database tables in DevKinta to make sure they have the correct domain entry which should be “sitename.local”
I’m glad to hear that it’s now working. However, we don’t have a specific timeframe for when the Pull Site action will operate seamlessly for Multisite. I will pass your inquiry along as feedback to our DevKinsta engineering team. I’ve also removed all sensitive information from this thread.
