Problem with first site setup from WPEngine backup. SQL errors?

[mgason]

First time user.
I downloaded a backup from WPEngine to do a manual import.
I went to file import and said import the zip named babasouk.zip
Named the site babasouk.
The site folder appears in File manager.

The import seemed to run fine, then it asked for my admin credentials and started DB import. I got the error in the screenshot.
When I click view site in Local the browser takes me to the site. It loads but not not with the child theme I use. It loads the parent theme.
When I try to login using my username and password from the actual site it does not allow me to. I tried a PW reset it said unknown email.

Some additional information. All of the blog posts appear to be there. The site is a woocommerce store. None of the products are there.

[mgason]

Does anyone have any ideas?

[ben.turner]

Hey @mgason – Welcome to the forums!

What you are describing sounds like there’s some sort of SQL file (or files) that are causing issues when importing and because of that, Local isn’t able to fully finish setting up the site.

Have you taken a look at the Local log to see if there ar any errors? If you provide your Local Log, we can take a look here as well. See this Community Forum post for instructions on how to do so:

• How do I retrieve Local’s Log?

One other thing you might try is extracting the zip file somewhere temporarily, and then try and find the main SQL file. From there, you can zip that file up with the wp-contents folder and import the newly created zip to a new site in Local. Let us know if that helps fix things, or if you find anything in the Local log!

[mgason]

Hi,
I tried again with a new backup download after clearing the log. I got the same errors. I putting the log at the end of this post.
I will try what you mentioned. I am not entirely sure about your instructions. Should I…
unpack the download
zip contents folder and sql file
import that as a new site, using File/Import Site
OR
make a new empty site
then import the data somehow

{"thread":"worker","worker":"analyzeImportWorker","level":"info","message":"checkLocalExport","timestamp":"2020-09-15T04:34:55.748Z"}
{"thread":"worker","worker":"analyzeImportWorker","level":"info","message":"Analyzing Zip: Listing Contents for Local Export Check","timestamp":"2020-09-15T04:34:55.749Z"}
{"thread":"worker","worker":"analyzeImportWorker","level":"info","message":"checkBackupBuddy","timestamp":"2020-09-15T04:34:55.751Z"}
{"thread":"worker","worker":"analyzeImportWorker","level":"info","message":"checkGenericZip","timestamp":"2020-09-15T04:34:55.752Z"}
{"thread":"worker","worker":"analyzeImportWorker","level":"info","message":"Analyzing Zip: Listing Contents for Generic Zip Check","timestamp":"2020-09-15T04:34:55.753Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2020-09-15T05:34:58.677Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2020-09-15T05:34:58.682Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2020-09-15T05:34:58.685Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2020-09-15T05:34:58.909Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%/lightning-services/mysql-8.0.16+5/lib/main.js","timestamp":"2020-09-15T05:34:58.912Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%/lightning-services/mysql-8.0.16+5/lib/main.js","timestamp":"2020-09-15T05:34:59.071Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%/lightning-services/nginx-1.16.0+3/lib/main.js","timestamp":"2020-09-15T05:34:59.074Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%/lightning-services/nginx-1.16.0+3/lib/main.js","timestamp":"2020-09-15T05:34:59.219Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%resourcesPath%%/lightning-services/php-7.3.5+10/lib/main.js","timestamp":"2020-09-15T05:34:59.223Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%resourcesPath%%/lightning-services/php-7.3.5+10/lib/main.js","timestamp":"2020-09-15T05:34:59.364Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%appPath%%/node_modules/@getflywheel/local-addon-broken-link-checker/lib/main.js","timestamp":"2020-09-15T05:34:59.366Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%appPath%%/node_modules/@getflywheel/local-addon-broken-link-checker/lib/main.js","timestamp":"2020-09-15T05:34:59.367Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/local-browsersync/package.json","level":"info","timestamp":"2020-09-15T05:34:59.368Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/local-browsersync-client/package.json","level":"info","timestamp":"2020-09-15T05:34:59.369Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/local-components/package.json","level":"info","timestamp":"2020-09-15T05:34:59.370Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localcert/package.json","level":"info","timestamp":"2020-09-15T05:34:59.370Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localtunnel/package.json","level":"info","timestamp":"2020-09-15T05:34:59.371Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/memoize-one-ts/package.json","level":"info","timestamp":"2020-09-15T05:34:59.372Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"main\" or \"renderer\" specified in package.json: %%appPath%%/node_modules/@getflywheel/replacestream/package.json","level":"info","timestamp":"2020-09-15T05:34:59.372Z"}
{"thread":"renderer","component":"ImportSiteAnalyzePage","level":"info","message":"Message from import-site-analyze-worker:","timestamp":"2020-09-15T05:35:20.302Z"}

[ben.turner]

@mgason

Should I…
unpack the download
zip contents folder and sql file
import that as a new site, using File/Import Site
OR
make a new empty site
then import the data somehow

Either of those workflows would work. I would start by working through that first workflow. To help you visualize, you can try following the steps outlined in the “Restoring From Only Local Site files” section of this help doc:

• Import/Export a WordPress Site - Local

If you do have to go with the second workflow, then, yes, create a new site and then take whatever sql file is located in the backup and import it using something like Adminer, followed by doing a manual search and replace for the domain.

Let me know if you get that far and need any additional pointers!

[mgason]

I am not having much luck.
I tried unpacking the WPEngine backup download.
I zipped wp-content and the sql file (prior to getting your further instructions) Local said "Sorry couldn’t work out what to do with that file)
I then zipped up all of the backup file again and curiously got the same error when I tried to import it, which made no sense to me. Attached is a screenshot of the backup contents I re-zipped.
What can I leave out if trying to make a new zip.

[ben.turner]

That wp-snapshots folder may be causing issues. If I remember correctly, I think that this folder stores a number of sql files within it.

Can you try excluding the wp-snapshots folder from the newly created zip and import that?