SQL error when migrating from Local By Flywheel to Local

I’m trying to migrate a site from LbF 3.3.0 to Local 5.2.5, running on macOS 10.14.6 (Mojave). I’ve exported the site successfully and the files appear to be imported without issue, but then the importer falls over on the database every time.

The LbF site is running MySQL 5.6.34, but the only option available in Local is 5.7.28, so that may be a contributing factor, but I have no way to equalise the versions in both applications.

I’ve attached the displayed error messages but can’t find any logs for this new version, so if anyone knows where I should look, please let me know.

Hi Gary,

Sorry for the trouble migrating!

Can you please provide the local-lightning.log file in its entirety? See How do I retrieve Local's log file? for instructions on how to do so.

Hi Clay,
So I’m attaching three files. local-lightning.log is the original file that should contain my initial attempts. local-lightning-sequel.log is the log from when I tried replacing the SQL script with one that I exported from Sequel Pro and local-lightning-wut.log is when I tried re-importing the original archive and… it worked. :flushed:

local-lightning.log (191.4 KB)
local-lightning-sequel.log (17.5 KB)
local-lightning-wut.log (12.3 KB)

Here is the log file:

{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.540Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.543Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.544Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.572Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.573Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.603Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.604Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.633Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.633Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T19:53:52.663Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.559Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.561Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.562Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.591Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.592Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.621Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.622Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.652Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.653Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T19:59:02.680Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkLocalExport”,“timestamp”:“2020-03-19T19:59:18.582Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Local Export Check”,“timestamp”:“2020-03-19T19:59:18.582Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“debug”,“message”:“Analysis of zip: Local Export”,“timestamp”:“2020-03-19T19:59:18.582Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkBackupBuddy”,“timestamp”:“2020-03-19T19:59:18.583Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkGenericZip”,“timestamp”:“2020-03-19T19:59:18.583Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Generic Zip Check”,“timestamp”:“2020-03-19T19:59:18.584Z”}
{“thread”:“renderer”,“component”:“ImportSiteAnalyzePage”,“level”:“info”,“message”:“Message from import-site-analyze-worker:”,“timestamp”:“2020-03-19T19:59:18.627Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:00:53.247Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:00:53.250Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:00:53.271Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/RtS6wu94M/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:00:53.332Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:00:56.869Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:00:57.153143Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 1135”,“timestamp”:“2020-03-19T20:00:57.588Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:00:57.155116Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:00:57.588Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:00:57.156051Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/RtS6wu94M/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:00:57.589Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:00:57.565823Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:00:57.589Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:00:57.588593Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/RtS6wu94M/mysql/mysqld.sock’ port: 10004 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:00:57.589Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:00:57.741Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:00:57.772Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:00:57.829Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2020-03-19T20:00:57.858Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing /Users/laz/Local/app/sql/local.sql”,“timestamp”:“2020-03-19T20:00:58.001Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1109 (42S02) at line 2049: Unknown table ‘INNODB_LOCK_WAITS’ in information_schema\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:17860)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“error”,“message”:“Unable to import /Users/laz/Local/app/sql/local.sql”,“timestamp”:“2020-03-19T20:00:58.556Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1131,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:00:58.557Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:1132,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:00:58.558Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:1134,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:00:58.558Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:1135,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:00:58.558Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Removing /var/folders/jq/cnhgtshd76x9kdrkwmp8w5980000gp/T/local-by-flywheel-JaPzdcbAQ1”,“timestamp”:“2020-03-19T20:00:58.558Z”}
{“stack”:“Error: Local was unable to import the following SQL files: \n\n• /app/sql/local.sql\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:18153)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“warn”,“message”:“Unable to import site.”,“timestamp”:“2020-03-19T20:00:58.559Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting /Users/laz/Library/Application Support/Local/run/RtS6wu94M”,“level”:“info”,“timestamp”:“2020-03-19T20:01:19.129Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:01:19.167Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:01:19.933Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:01:29.569Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkLocalExport”,“timestamp”:“2020-03-19T20:01:51.386Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Local Export Check”,“timestamp”:“2020-03-19T20:01:51.387Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“debug”,“message”:“Analysis of zip: Local Export”,“timestamp”:“2020-03-19T20:01:51.387Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkBackupBuddy”,“timestamp”:“2020-03-19T20:01:51.387Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkGenericZip”,“timestamp”:“2020-03-19T20:01:51.388Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Generic Zip Check”,“timestamp”:“2020-03-19T20:01:51.388Z”}
{“thread”:“renderer”,“component”:“ImportSiteAnalyzePage”,“level”:“info”,“message”:“Message from import-site-analyze-worker:”,“timestamp”:“2020-03-19T20:01:51.432Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1147,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:02:14.356Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.088Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.090Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.090Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.121Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.122Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.153Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.154Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.178Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.178Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:12:26.204Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkLocalExport”,“timestamp”:“2020-03-19T20:12:44.381Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Local Export Check”,“timestamp”:“2020-03-19T20:12:44.382Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“debug”,“message”:“Analysis of zip: Local Export”,“timestamp”:“2020-03-19T20:12:44.382Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkBackupBuddy”,“timestamp”:“2020-03-19T20:12:44.383Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkGenericZip”,“timestamp”:“2020-03-19T20:12:44.383Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Generic Zip Check”,“timestamp”:“2020-03-19T20:12:44.384Z”}
{“thread”:“renderer”,“component”:“ImportSiteAnalyzePage”,“level”:“info”,“message”:“Message from import-site-analyze-worker:”,“timestamp”:“2020-03-19T20:12:44.426Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:12:55.100Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:12:55.103Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:12:55.125Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/h6Blv73RN/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:12:55.187Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:12:58.652Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:12:58.799Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:12:58.852144Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 1606”,“timestamp”:“2020-03-19T20:12:59.227Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:12:58.854085Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:12:59.228Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:12:58.854955Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/h6Blv73RN/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:12:59.228Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:12:59.204263Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:12:59.228Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:12:59.227728Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/h6Blv73RN/mysql/mysqld.sock’ port: 10004 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:12:59.228Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:12:59.477Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:12:59.870Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2020-03-19T20:12:59.889Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing /Users/laz/Local Sites/test/app/sql/local.sql”,“timestamp”:“2020-03-19T20:13:00.005Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1109 (42S02) at line 2049: Unknown table ‘INNODB_LOCK_WAITS’ in information_schema\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:17860)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“error”,“message”:“Unable to import /Users/laz/Local Sites/test/app/sql/local.sql”,“timestamp”:“2020-03-19T20:13:00.500Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1602,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:00.502Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:1603,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:00.502Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:1605,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:00.502Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:1606,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:00.503Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Removing /var/folders/jq/cnhgtshd76x9kdrkwmp8w5980000gp/T/local-by-flywheel-msc5hYVG2K”,“timestamp”:“2020-03-19T20:13:00.503Z”}
{“stack”:“Error: Local was unable to import the following SQL files: \n\n• /app/sql/local.sql\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:18153)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“warn”,“message”:“Unable to import site.”,“timestamp”:“2020-03-19T20:13:00.503Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting /Users/laz/Library/Application Support/Local/run/h6Blv73RN”,“level”:“info”,“timestamp”:“2020-03-19T20:13:14.924Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:13:14.952Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:13:15.723Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:13:22.524Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkLocalExport”,“timestamp”:“2020-03-19T20:13:36.346Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Local Export Check”,“timestamp”:“2020-03-19T20:13:36.347Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“debug”,“message”:“Analysis of zip: Local Export”,“timestamp”:“2020-03-19T20:13:36.347Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkBackupBuddy”,“timestamp”:“2020-03-19T20:13:36.347Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkGenericZip”,“timestamp”:“2020-03-19T20:13:36.348Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Generic Zip Check”,“timestamp”:“2020-03-19T20:13:36.348Z”}
{“thread”:“renderer”,“component”:“ImportSiteAnalyzePage”,“level”:“info”,“message”:“Message from import-site-analyze-worker:”,“timestamp”:“2020-03-19T20:13:36.392Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:13:44.318Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:13:44.320Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:13:44.334Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/95h30hgMO/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:13:44.378Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:13:47.804Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1609,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:47.962Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:13:47.976Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:13:48.003958Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 1831”,“timestamp”:“2020-03-19T20:13:48.417Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:13:48.005919Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:13:48.417Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:13:48.006887Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/95h30hgMO/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:13:48.417Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:13:48.394676Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:13:48.417Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:13:48.417217Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/95h30hgMO/mysql/mysqld.sock’ port: 10004 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:13:48.418Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:13:48.624Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:13:49.064Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2020-03-19T20:13:49.088Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing /Users/laz/Local Sites/test/app/sql/local.sql”,“timestamp”:“2020-03-19T20:13:49.264Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1109 (42S02) at line 2049: Unknown table ‘INNODB_LOCK_WAITS’ in information_schema\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:17860)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:85:5)”,“level”:“error”,“message”:“Unable to import /Users/laz/Local Sites/test/app/sql/local.sql”,“timestamp”:“2020-03-19T20:13:49.775Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1827,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:49.776Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:1828,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:49.777Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:1830,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:49.777Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:1831,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:13:49.777Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Removing /var/folders/jq/cnhgtshd76x9kdrkwmp8w5980000gp/T/local-by-flywheel-ZmKn8qSGHv”,“timestamp”:“2020-03-19T20:13:49.777Z”}
{“stack”:“Error: Local was unable to import the following SQL files: \n\n• /app/sql/local.sql\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:18153)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:85:5)”,“level”:“warn”,“message”:“Unable to import site.”,“timestamp”:“2020-03-19T20:13:49.777Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting /Users/laz/Library/Application Support/Local/run/95h30hgMO”,“level”:“info”,“timestamp”:“2020-03-19T20:14:05.684Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:14:05.707Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:14:06.476Z”}
{“thread”:“main”,“class”:“HostsFileService”,“error”:{“message”:“User did not grant permission.”,“stack”:“Error: User did not grant permission.\n at ReadFileContext.callback (/Applications/Local.app/Contents/Resources/app.asar/node_modules/sudo-prompt/index.js:377:49)\n at FSReqCallback.readFileAfterOpen [as oncomplete] (fs.js:246:13)”},“level”:“error”,“message”:“Could not update hosts.”,“timestamp”:“2020-03-19T20:14:08.624Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:14:43.384Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:14:43.387Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:14:43.411Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/-9O08lPcy/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:14:43.458Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:14:46.901Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1844,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:14:47.040Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:14:47.058Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:14:47.102096Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 1997”,“timestamp”:“2020-03-19T20:14:47.478Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:14:47.104032Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:14:47.478Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:14:47.105165Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/-9O08lPcy/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:14:47.478Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:14:47.460712Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:14:47.479Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:14:47.478281Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/-9O08lPcy/mysql/mysqld.sock’ port: 10004 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:14:47.479Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:14:48.120Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Init WordPressInstaller”,“level”:“info”,“timestamp”:“2020-03-19T20:14:48.139Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Starting standardInstall()”,“level”:“info”,“timestamp”:“2020-03-19T20:14:48.139Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“maybeGetLatestVersion()”,“level”:“info”,“timestamp”:“2020-03-19T20:14:48.140Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“latestOfflineWpVersion”:null,“level”:“info”,“message”:“Latest offline version info”,“timestamp”:“2020-03-19T20:14:48.140Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“version”:“5.3.2”,“download”:“[https://downloads.wordpress.org/release/wordpress-5.3.2.tar.gz",“level”:“info”,“message”:"Latest](https://downloads.wordpress.org/release/wordpress-5.3.2.tar.gz%22,%22level%22:%22info%22,%22message%22:%22Latest) version info”,“timestamp”:“2020-03-19T20:14:48.297Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“level”:“info”,“message”:“download()”,“timestamp”:“2020-03-19T20:14:48.297Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“level”:“info”,“message”:“Attempting to download WordPress”,“timestamp”:“2020-03-19T20:14:48.297Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Configuring wp-config.php”,“level”:“info”,“timestamp”:“2020-03-19T20:15:04.473Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Installing WordPress”,“level”:“info”,“timestamp”:“2020-03-19T20:15:04.883Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Deleting Akismet and Hello Dolly”,“level”:“info”,“timestamp”:“2020-03-19T20:15:05.980Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Writing salts to wp-config.php”,“level”:“info”,“timestamp”:“2020-03-19T20:15:06.618Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkLocalExport”,“timestamp”:“2020-03-19T20:15:23.941Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Local Export Check”,“timestamp”:“2020-03-19T20:15:23.942Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“debug”,“message”:“Analysis of zip: Local Export”,“timestamp”:“2020-03-19T20:15:23.942Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkBackupBuddy”,“timestamp”:“2020-03-19T20:15:23.942Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkGenericZip”,“timestamp”:“2020-03-19T20:15:23.943Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Generic Zip Check”,“timestamp”:“2020-03-19T20:15:23.943Z”}
{“thread”:“renderer”,“component”:“ImportSiteAnalyzePage”,“level”:“info”,“message”:“Message from import-site-analyze-worker:”,“timestamp”:“2020-03-19T20:15:24.428Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:18:21.462Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:18:21.465Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:18:21.486Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/CIzGOsvGA/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:18:21.546Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:18:25.058Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:18:25.252273Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 2193”,“timestamp”:“2020-03-19T20:18:25.758Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:18:25.256279Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:18:25.758Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:18:25.257415Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/CIzGOsvGA/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:18:25.759Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:18:25.734565Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:18:25.759Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:18:25.758509Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/CIzGOsvGA/mysql/mysqld.sock’ port: 10009 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:18:25.759Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:2001,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:18:25.835Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:18:25.847Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:18:25.878Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:18:25.891Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2020-03-19T20:18:25.915Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing /Users/laz/Local Sites/collection/app/sql/local.sql”,“timestamp”:“2020-03-19T20:18:26.049Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:18:36.200Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1109 (42S02) at line 49763: Unknown table ‘INNODB_LOCK_WAITS’ in information_schema\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:17860)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“error”,“message”:“Unable to import /Users/laz/Local Sites/collection/app/sql/local.sql”,“timestamp”:“2020-03-19T20:19:12.585Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:2189,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:19:12.587Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:2190,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:19:12.587Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:2192,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:19:12.587Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:2193,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:19:12.587Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Removing /var/folders/jq/cnhgtshd76x9kdrkwmp8w5980000gp/T/local-by-flywheel-PW1UO05g0t”,“timestamp”:“2020-03-19T20:19:12.588Z”}
{“stack”:“Error: Local was unable to import the following SQL files: \n\n• /app/sql/local.sql\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:18153)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“warn”,“message”:“Unable to import site.”,“timestamp”:“2020-03-19T20:19:12.588Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting /Users/laz/Library/Application Support/Local/run/CIzGOsvGA”,“level”:“info”,“timestamp”:“2020-03-19T20:19:23.269Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:19:24.081Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:19:33.298Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkLocalExport”,“timestamp”:“2020-03-19T20:20:16.495Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Local Export Check”,“timestamp”:“2020-03-19T20:20:16.496Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“debug”,“message”:“Analysis of zip: Local Export”,“timestamp”:“2020-03-19T20:20:16.496Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkBackupBuddy”,“timestamp”:“2020-03-19T20:20:16.496Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkGenericZip”,“timestamp”:“2020-03-19T20:20:16.497Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Generic Zip Check”,“timestamp”:“2020-03-19T20:20:16.497Z”}
{“thread”:“renderer”,“component”:“ImportSiteAnalyzePage”,“level”:“info”,“message”:“Message from import-site-analyze-worker:”,“timestamp”:“2020-03-19T20:20:16.989Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:22:12.948Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:22:12.951Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:22:12.972Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/MM_Eqof-I/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:22:13.036Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:22:16.493Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:2211,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:22:16.636Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:22:16.646Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:22:16.691951Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 2615”,“timestamp”:“2020-03-19T20:22:17.150Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:22:16.693885Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:22:17.151Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:22:16.694946Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/MM_Eqof-I/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:22:17.151Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:22:17.128592Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:22:17.151Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:22:17.150636Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/MM_Eqof-I/mysql/mysqld.sock’ port: 10009 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:22:17.151Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:22:17.325Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:22:17.706Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2020-03-19T20:22:17.726Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing /Users/laz/Local Sites/collection/app/sql/local.sql”,“timestamp”:“2020-03-19T20:22:17.836Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:22:28.940Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1109 (42S02) at line 49763: Unknown table ‘INNODB_LOCK_WAITS’ in information_schema\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:17860)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:85:5)”,“level”:“error”,“message”:“Unable to import /Users/laz/Local Sites/collection/app/sql/local.sql”,“timestamp”:“2020-03-19T20:23:02.431Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:2611,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:02.432Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:2612,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:02.433Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:2614,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:02.433Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:2615,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:02.433Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Removing /var/folders/jq/cnhgtshd76x9kdrkwmp8w5980000gp/T/local-by-flywheel-bWHNPLOFSp”,“timestamp”:“2020-03-19T20:23:02.433Z”}
{“stack”:“Error: Local was unable to import the following SQL files: \n\n• /app/sql/local.sql\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:18153)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:85:5)”,“level”:“warn”,“message”:“Unable to import site.”,“timestamp”:“2020-03-19T20:23:02.434Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting /Users/laz/Library/Application Support/Local/run/MM_Eqof-I”,“level”:“info”,“timestamp”:“2020-03-19T20:23:19.866Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:23:20.676Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1993,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:25.891Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:1994,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:25.892Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:1996,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:25.892Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:1997,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:25.892Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:2618,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:23:25.893Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.460Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.462Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.463Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.490Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.490Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.519Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.520Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.548Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.548Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:26:31.575Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.801Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.804Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.806Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.851Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.853Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.917Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.919Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.960Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:49.962Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:38:50.008Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting /Users/laz/Library/Application Support/Local/run/-9O08lPcy”,“level”:“info”,“timestamp”:“2020-03-19T20:39:04.911Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:39:05.718Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:39:14.453Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:24.945Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mailhog-1.0.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:24.947Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:24.948Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mariadb-10.4.10+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:24.977Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:24.977Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:25.007Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:25.008Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/nginx-1.16.0+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:25.033Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:25.033Z”}
{“thread”:“main”,“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/php-7.3.5+3/lib/main.js”,“timestamp”:“2020-03-19T20:43:25.056Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:44:02.201Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:44:02.207Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:44:02.241Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/1GxxzrUcS/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:44:02.311Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:44:05.938Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:44:06.183414Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 982”,“timestamp”:“2020-03-19T20:44:06.604Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:44:06.185828Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:44:06.604Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:44:06.186769Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/1GxxzrUcS/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:44:06.604Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:44:06.581147Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:44:06.605Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:44:06.604275Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/1GxxzrUcS/mysql/mysqld.sock’ port: 10004 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:44:06.605Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:44:06.689Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:44:06.781Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Init WordPressInstaller”,“level”:“info”,“timestamp”:“2020-03-19T20:44:06.798Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Starting standardInstall()”,“level”:“info”,“timestamp”:“2020-03-19T20:44:06.799Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“maybeGetLatestVersion()”,“level”:“info”,“timestamp”:“2020-03-19T20:44:06.799Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“latestOfflineWpVersion”:“5.3.2”,“level”:“info”,“message”:“Latest offline version info”,“timestamp”:“2020-03-19T20:44:06.799Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:44:06.802Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“version”:“5.3.2”,“download”:“[https://downloads.wordpress.org/release/wordpress-5.3.2.tar.gz",“level”:“info”,“message”:"Latest](https://downloads.wordpress.org/release/wordpress-5.3.2.tar.gz%22,%22level%22:%22info%22,%22message%22:%22Latest) version info”,“timestamp”:“2020-03-19T20:44:06.972Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Configuring wp-config.php”,“level”:“info”,“timestamp”:“2020-03-19T20:44:11.315Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Installing WordPress”,“level”:“info”,“timestamp”:“2020-03-19T20:44:11.731Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Deleting Akismet and Hello Dolly”,“level”:“info”,“timestamp”:“2020-03-19T20:44:12.704Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Writing salts to wp-config.php”,“level”:“info”,“timestamp”:“2020-03-19T20:44:14.874Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:44:18.600Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:978,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:14.091Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:979,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:14.091Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:980,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:14.092Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:982,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:14.092Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkLocalExport”,“timestamp”:“2020-03-19T20:45:38.422Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Local Export Check”,“timestamp”:“2020-03-19T20:45:38.423Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“debug”,“message”:“Analysis of zip: Local Export”,“timestamp”:“2020-03-19T20:45:38.423Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkBackupBuddy”,“timestamp”:“2020-03-19T20:45:38.423Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“checkGenericZip”,“timestamp”:“2020-03-19T20:45:38.424Z”}
{“thread”:“worker”,“worker”:“analyzeImportWorker”,“level”:“info”,“message”:“Analyzing Zip: Listing Contents for Generic Zip Check”,“timestamp”:“2020-03-19T20:45:38.424Z”}
{“thread”:“renderer”,“component”:“ImportSiteAnalyzePage”,“level”:“info”,“message”:“Message from import-site-analyze-worker:”,“timestamp”:“2020-03-19T20:45:38.470Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2020-03-19T20:45:51.174Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2020-03-19T20:45:51.177Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:45:51.196Z”}
{“thread”:“main”,“dataPath”:"/Users/laz/Library/Application Support/Local/run/ShxhQQwxD/mysql/data",“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2020-03-19T20:45:51.257Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2020-03-19T20:45:54.728Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:992,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:54.868Z”}
{“thread”:“main”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2020-03-19T20:45:54.879Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:45:54.932457Z 0 [System] [MY-010116] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 1287”,“timestamp”:“2020-03-19T20:45:55.332Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:45:54.934621Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“timestamp”:“2020-03-19T20:45:55.332Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:45:54.935624Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/laz/Library/Application Support/Local/run/ShxhQQwxD/mysql/data/ is case insensitive”,“timestamp”:“2020-03-19T20:45:55.332Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:45:55.309998Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2020-03-19T20:45:55.333Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2020-03-19T20:45:55.332344Z 0 [System] [MY-010931] [Server] /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+3/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘/Users/laz/Library/Application Support/Local/run/ShxhQQwxD/mysql/mysqld.sock’ port: 10009 MySQL Community Server - GPL.”,“timestamp”:“2020-03-19T20:45:55.333Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:45:55.559Z”}
{“thread”:“main”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2020-03-19T20:45:55.973Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2020-03-19T20:45:56.000Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Importing /Users/laz/Local Sites/test/app/sql/local.sql”,“timestamp”:“2020-03-19T20:45:56.144Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“stack”:“Error: ERROR 1109 (42S02) at line 2049: Unknown table ‘INNODB_LOCK_WAITS’ in information_schema\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:17860)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“error”,“message”:“Unable to import /Users/laz/Local Sites/test/app/sql/local.sql”,“timestamp”:“2020-03-19T20:45:56.712Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1283,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:56.714Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:1284,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:56.714Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:1286,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:56.715Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:1287,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:45:56.715Z”}
{“thread”:“main”,“class”:“ImporterLocalExport”,“level”:“info”,“message”:“Removing /var/folders/jq/cnhgtshd76x9kdrkwmp8w5980000gp/T/local-by-flywheel-mGrZKODa4t”,“timestamp”:“2020-03-19T20:45:56.716Z”}
{“stack”:“Error: Local was unable to import the following SQL files: \n\n• /app/sql/local.sql\n at ImporterLocalExport. (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:18153)\n at Generator.next ()\n at _0x5105ed (/Applications/Local.app/Contents/Resources/app.asar/main/importer/Importer.js:1:3850)”,“level”:“warn”,“message”:“Unable to import site.”,“timestamp”:“2020-03-19T20:45:56.716Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting /Users/laz/Library/Application Support/Local/run/ShxhQQwxD”,“level”:“info”,“timestamp”:“2020-03-19T20:47:06.583Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:47:06.615Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2020-03-19T20:47:07.387Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at /etc/hosts\nUpdated hosts file at /etc/hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2020-03-19T20:47:15.157Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:1290,“level”:“info”,“message”:“Killing process”,“timestamp”:“2020-03-19T20:47:20.819Z”}

Thanks @genyus and @cwbuff! We’ll be looking into this soon.

1 Like

Any luck yet?

Although the archive did eventually import for me after several failed attempts, the successful workaround I tried first was to export the database for the original site via Sequel Pro, export the site, unzip the archive, replace import.sql with the Sequel script (keeping the same file name), re-zip it and then import.

Is there a link to download the old version of Local? Will that allow me to restore my site from export backup?

You want Local by Flywheel 3.3.0 — it should let you restore your backup

Local by Flywheel 3.3.0 will not install. It stays in an endless loop “Checking System”. Do I have to uninstall Local 5 first?

It looks like it did not install VirtualBox. Is that in the installation dmg file?

If you’re having problems with the installation process, I’d suggest you create a new topic and include all the necessary details to get better assistance.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.