Hello,
I am having problems importing my SQL database to LocalWP by Flywheel.
I have already created a new site using the current site's PHP, Web Server, and Database. As well as, importing the public_html files to the /site/app/public/ directory.
The problem lies when I try to import the SQL database via AdminerEvo web config, it gives me an error stating
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 130023456 bytes) in C:\Users\josea\AppData\Local\Programs\Local\resources\extraResources\adminer\adminer.php on line 100
I then tried to manually import the SQL Database to LocalWP via CLI and it would either tell me I don't have enough memory or it would say, failed to get current SQL modes, and that it couldn't connect to the SQL Database even though the LocalWP site was running at that time.
If anyone has any other way or solution to import the SQL Database it would greatly be appreciated.
Look for this line in your php.ini file.
memory_limit = 256M and change it to 512M
If it’s shared hosting, 256M might be the ceiling of what’s allowable.