Local WP – Adminer running out of memory upon sql import – Fatal error

Actually we can now use “wp” command line and following method worked for me.

  1. Put the desired site.sql file into /app/public/ folder
  2. Open Site SSH from Local WP (previously flywheel)
  3. You should be able to use “wp” command line
  4. Type command – wp db import site.sql

This used to work before but it is not

This is the exact copy from the flywheel forum community. Link to the original page is below. This is a great answer. Enjoy

Adminer running out of memory upon sql import – Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 174873888 bytes) in /etc/scripts/local-adminer.php on line 92

In this case I would recommend using MySQL CLI (command line) to get this job done.

Here’s what you can do –

  1. Move the SQL file into the site’s /app directory (untar it if it’s tar/gzipped)
  2. Right-click on the site in Local’s sidebar and go to “Open Site SSH”
  3. Enter mysql -u root -proot local < /app/SQLFILENAME.sql (replace SQLFILENAME.sql with the correct name) and then press enter