Problem pushing database from Local to Flywheel

Support
1

I pushed a site entirely made in Local to a new Flywheel I account I just set up with an empty site. The push to existing site seems to have worked well, but when trying to see and work on the site at Flywheel it doesn’t show up. From Flywheel support I learned that the database had not transferred correctly. The only error they could find in their log says:

ERROR 1100 (HY000) at line 6227: Table ‘wp_postmeta’ was not locked with LOCK TABLES

I can see that the files have transferred correctly, but none of the database.
Flywheel support concludes the problem is at the LOCAL side. What do I need to do to to fix this?

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

System Details

  • Local Version:
    Local 9.0.5 +6706

  • Operating System (OS) and OS version:
    Mac OS Sonoma 14.1

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

2

Hi @niclas

This error doesn’t indicate an issue with Local or Flywheel I believe but with the database. Here is a StackOverflow thread with more details and some potential workarounds or troubleshooting steps you could try: