Error Pulling from WPEngine to new site (autoload.sql)

[jessicalynncodes]

I am trying to pull a site and database locally, and have tried both an existing and fresh install. When including the database, I get the following error:

Error: Local was unable to import the following SQL files:

• /app/public/_wpeprivate/autoload.sql

The seemingly relevant error immediately before this notice in the log is:

{“thread”:“main”,“class”:“r”,“stack”:“Error: ERROR 1118 (42000) at line 2409: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.\n at r. (%%appPath%%/main/importer/Importer.js:1:8305)\n at Generator.next ()\n at a (%%appPath%%/main/importer/Importer.js:1:124)”,“level”:“error”,“message”:“Unable to import /Users/jessica/Local Sites/xx/app/public/_wpeprivate/autoload.sql”,“timestamp”:“2020-09-03T21:10:02.903Z”}

It seemingly stops importing the database at this point, so the site will not work locally. Any help is appreciated, thanks!

[cw-joseph]

Bumping this thread. I’m also having this issue.

[jessicalynncodes]

Hi! I don’t know how much it will help you, but what I ended up doing was pulling the site’s files down without a database, and then exporting / using sequel pro to import the database so that I could catch where exactly the errors were occurring. With my specific site, all of the errors were from tables created by old plugins we weren’t using anymore, so I was able to just delete them entirely and import the database without issues. I also deleted them off of our production site’s database, and now it is pulling with Local just fine.

I didn’t dive deeper into what the issues were since the tables were no longer needed, but hope it’s at least a step in the right direction if you don’t get a response back here!