PHP memory limit error when importing a SQL file in Adminer

Support
2

That error is basically saying that PHP (the underlying software running Adminer) didn’t have enough memory to handle the upload of that SQL file.

Are you able to import the site by creating a zip of the sql file along with the wp-content folder? Something like what’s outlined in the “Restoring From Only Local Site files” section of this help doc:

If you do need to manually import the database of a large SQL file, I recommend using the terminal since it is much more efficient and doesn’t run into these sorts of memory issues. To do this:

  1. Copy the sql file to the site root. That location should be something like: ~/Local Sites/sitename/app/public/

  2. Right-click on the site in Local and select “Open site shell”

  3. Within the terminal that opens, import the sql file using this command:

    wp db import name-of-sql-file.sql

  4. Since this is being done manually, you’ll likely need to search for the old domain and replace it with the new domain. That command looks something like:

    wp search-replace '//example.com' '//example.local'

Can you let us know if either of those workflows gets you what you need?