Unable to import Database from Production hosted on Flywheel

What issue or error are you experiencing?

I re-created my LOCAL site from Flywheel. Everything was fine until I tried to import. It constantly failed. I decided to grab my wp-content folder from a production backup and make a database backup using WP Migrate. The database still failed. I opened site ssh and imported it using wp db import. It stopped 3 times with errors, I fixed these and proceeded.
I tried to PULL the production site but always got an error: “uh-oh! We ran into an issue when pulling from flywheel”. This always happened in the “Finalize” step.

I know the .connect-pull.sql is the problem but I can’t get access to see what the issue is. LOCAL has it locked down tight. When I stop the site it deletes the file.

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


This is the error I get. I did find this in “local-lightning.log”

    {"class":"ImporterConnectV2","level":"error","message":"Unable to import 
    C:\\Users\\johan\\Local Sites\\oi-society-australia\\app\\public\\.connect-pull.sql","stack":"Error: 
    ERROR at line 1: Unknown command '\\-'.\n    at 
    %%appPath%%\\main\\_helpers\\importSQLFile.js:112:19\n    at Generator.next 
    (<anonymous>)\n    at fulfilled (%%appPath%%\\main\\_helpers\\importSQLFile.js:28:58)\n    
    at process.processTicksAndRejections 
    (node:internal/process/task_queues:95:5)","thread":"main","timestamp":"2025-01- 
    23T07:18:10.168Z"}
    {"class":"FlywheelPullService","level":"error","message":"Error: Local was unable to import the 
    following SQL files: \n\n• \\app\\public\\.connect-pull.sql\n    at ImporterConnectV2. 
    <anonymous> (%%appPath%%\\main\\importer\\Importer.js:348:23)\n    at Generator.throw 
    (<anonymous>)\n    at rejected (%%appPath%%\\main\\importer\\Importer.js:29:65)\n    at 
    process.processTicksAndRejections 
    (node:internal/process/task_queues:95:5)","thread":"main","timestamp":"2025-01- 
   23T07:18:10.170Z"} 

System Details

  • Local Version:
    Version 9.2.0+6762
  • Operating System (OS) and OS version:
    Edition: Windows 11 Pro
    Version: 24H2
    Installed on: ‎13/‎12/‎2024
    OS build: 26100.2894
    Experience: Windows Feature Experience Pack 1000.26100.36.0

Local Logs

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

Logs.zip (56.9 KB)

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.

Hi @Manbearpig73

I noticed in your screenshot you’re trying to pull to an Apache server, but Flywheel only utilizes NGINX. Are you trying to change the configuration?

Have you been able to pull/import this site in the past without issue? I see some entries in the logs from the months ago that seemed to complete.

I managed to track down the issue. It turns out the Plugin “WP Data Access” was the issue. It created tables with COLLATE=utf8mb4_0900_ai_ci that caused and import error. It also had a few rows that were not escaped properly and created more issues. When I removed the plugin and deleted all it 39 tables all was fine again.

I also switched back to NGINX although I never had issues before now using Apache.

1 Like

Great catch @Manbearpig73! I’ve seen some plugins cause issues like that in the past but when I took a look at your site earlier none of the common culprits I had come across were present so I wasn’t sure. Thank you for following up here and sharing!

1 Like

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