Local Community

Error Pulling Database from Production to Local

Issue Summary

Error received when pulling site:

Uh-oh! Unable to import site.
Error: Command failed: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’;

ERROR 1146 (42S02) at line 1: Table ‘local.wp_options’ doesn’t exist

I pulled the site about 2 weeks ago and it worked as always, this just started today.
Now when I go to my local version, my database has been wiped and its asking me to install a fresh version of wordpress when I visit the site locally.


Click pull site and select production

System Details

  • Which version of Local is being used?

  • What Operating System (OS) and OS version is being used?
    macOS Big Sur Version 11.4

local-lightning.log (264.2 KB) local-lightning1.log (1.0 MB) local-lightning2.log (1.0 MB) local-lightning3.log (1.0 MB) local-lightning4.log (583.5 KB) Uploading: local-lightning6.log…

solution: Import Error 1146: Command Failed

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