Unable to import new site - sql problem with timezone?

[Patch]

Issue Summary

I am trying add a site to local, but the import fails. I wondered if anyone could suggest a simple fix for this.

Looking in the log file it seems to suggest there is a problem with the Timezone.

The log file says

{“thread”:“main”,“class”:“ImporterGeneric”,“stack”:“Error: ERROR 1298 (HY000) at line 18: Unknown or incorrect time zone: ‘Europe/London’\n at %%appPath%%/main/_helpers/importSQLFile.js:1:2554\n at Generator.next ()\n at a (%%appPath%%/main/_helpers/importSQLFile.js:1:742)\n at runMicrotasks ()\n at processTicksAndRejections (internal/process/task_queues.js:93:5)”,“level”:“error”,“message”:“Unable to import /Users/Patrick/Local Sites/2022-03-04-09-17-44-5b3fqo2e01/app/sql/fertilis_wp459.sql”,“timestamp”:“2022-03-04T09:57:37.034Z”}

Line 18 which it is referring to in the sql file is
/*!40103 SET TIME_ZONE=‘Europe/London’ */;

Troubleshooting Questions

• Does this happen for all sites in Local, or just one in particular?
  This just seems to be happening with this site

• Are you able to create a new, plain WordPress site in Local and access it in a Browser?
  Yes, I can create a new site and access it with a browser. I can also access existing sites.

Replication

Describe the steps that others can take to replicate this issue. If you have screenshots that can help clarify what is happening, please include them!

I use backwpup to create a back up of a site (hosted on siteground).
Download the backup
Drag and drop it onto local
stick with the suggested settings
Enter my mac system password when required to
The import fails, then I have toenter my system password again

System Details

• Which version of Local is being used?
  Local 6.3.0+5756

• What Operating System (OS) and OS version is being used?
  MacOS 12.2.1 (21D62)

• Attach the Local Log. See this Help Doc for instructions on how to do so:

  • Retrieving Local’s Log

local-lightning.log (2.9 KB)

Thanks for any suggestions

Patch

[austinwendt]

Hi @Patch,

This is interesting, I haven’t seen that error before - it looks similar though to this StackOverflow post I found: Changing the connection timezone in MySQL - Stack Overflow

I wonder if running that command prior to exporting and then importing to Local will resolve the issue? It seems the files are missing that define the timezone.

Thanks,
Austin