How to resolve the issue with a huge DB to pull / import

What issue or error are you experiencing?

I’m trying to import a Flywheel backup zip. It’s not working because the SQL file is 400mb. This happened before with the same website, but then just by failing to pull the website via Local.

System Details

  • **Local Version: Version 9.0.3+6684 **

  • Operating System (OS) and OS version: OSX Sonoma 14.1

Local Logs

Error > {“level”:“warn”,“message”:“Unable to import site.”,“stack”:"Error: Local was unable to import the following SQL files: \n\n• /app/sql/backup.sql\n

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

Hi @duetcolin

The overall size of the DB shouldn’t really be an issue as I wouldn’t consider that to be on the large side quite yet. Unless it has some specific tables or rows with an issue.

As a workaround you could unzip the backup and then use our manual steps here to get it imported:

Manually Import a Local Site