# Import failed **URL:** \ **Category:** Support\ **Created:** [February 14, 2021, 11:51pm UTC](https://community.localwp.com/t/import-failed/24379 "2021-02-14T23:51:59Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![spirittlk](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/spirittlk/32/12543_2.png) [@spirittlk](https://community.localwp.com/u/spirittlk)\ **Post date:** [February 14, 2021, 11:52pm UTC](https://community.localwp.com/t/import-failed/24379/1 "2021-02-14T23:52:00Z")
### Issue Summary My original site is [https://www.visionsofheaven.com](https://www.visionsofheaven.com). I did a manual FTP download of the entire site. Duplicator quit because my site is too big, and I don’t see other options that are guaranteed to work with my server WPX Hosting. Next I used my host’s backup function to download the SQL database. It downloaded as “visionsofheaven\_com-backup.sql” I placed the site files in a folder named FILES in this path on my Mac: SITES \> VISIONS OFHEAVEN \> FILES I put the sql database in the same folder (see image below) SITES \> VISIONS OFHEAVEN \> visionsofheaven\_com-backup.sql I selected both the FILES folder and the sql database and used my Mac to create a zip file. I dragged the zip file into LOCAL It appeared to be loading. I selected PREFERRED OPTIONS because I didn’t know what else to do. My host uses PHP version up to 7.4, MySQL/Maria DB 10.4, and the Litespeed webserver I then got the following error from local and don’t know where to go from here. The current sql database has my original site path of “[https://www.visionsofheaven.com](https://www.visionsofheaven.com)” in it in various locations but I thought local would fix that upon import? The local log file is attached below. Any help is appreciated. Thank you! I’m getting an error - I typed this in and think I got spacing/dashes correct 🙂 “Uh oh! Unable to import site. Command failed /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+5/bin/darwin/bin/mysql/local -8 – disable-column-names -eSELECT option\_value FROM wp\_options WHERE option\_name = ‘site url’; ERROR 1146 (42SO2) at line 1: Table ‘local.wp\_options’ doesn’t exist.” Any ideas? thank you. I’d love to use this software. It looks fantastic, but I have no clue how to solve this." #### System Details Local Version 5.9.8+5191 (just downloaded it two days ago) Mac OSX Big Sur 11.2.1 [local-lightning.log](https://community.localwp.com/uploads/short-url/lAo3q5fIEitTxEkjn4Mg3oMoqMC.log) (60.4 KB) ![Source site downloaded to my SITES folder in subfolder VISIONS OFHEAVEN](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/7/7798ed92a9b11dd9df463790a46b5c66f3d05586.png) ---
**Author:** ![afragen](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/afragen/32/31_2.png) [@afragen](https://community.localwp.com/u/afragen)\ **Post date:** [February 15, 2021, 1:22am UTC](https://community.localwp.com/t/import-failed/24379/2 "2021-02-15T01:22:34Z")
The only files you need to include in the zip is the wp-content folder. ---
**Author:** ![ben.turner](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/ben.turner/32/5366_2.png) [@ben.turner](https://community.localwp.com/u/ben.turner)\ **Post date:** [February 15, 2021, 6:14pm UTC](https://community.localwp.com/t/import-failed/24379/3 "2021-02-15T18:14:22Z")
Hey @spirittlk – That specific error: ```auto Table ‘local.wp_options’ doesn’t exist. ``` Means that when Local tried to ask WordPress what the siteurl was, it couldn’t do it. As afragen mentioned, using just the sql dump and the `wp-content` folder may make things simpler. See following the steps outlined in the “Restoring From Only Local Site files” section of this help doc for more details on creating that zip: - [https://localwp.com/help-docs/how-to-import-a-wordpress-site-into-local/](https://localwp.com/help-docs/how-to-import-a-wordpress-site-into-local/) ---
**Author:** ![spirittlk](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/spirittlk/32/12543_2.png) [@spirittlk](https://community.localwp.com/u/spirittlk)\ **Post date:** [February 15, 2021, 6:37pm UTC](https://community.localwp.com/t/import-failed/24379/4 "2021-02-15T18:37:13Z")
Thank you, I decided to start from scratch and rebuild my entire site. It probably needs a good overhaul, but glad to know about this in case things go awry 🙂 ---
**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/system/32/1_2.png) [@system](https://community.localwp.com/u/system)\ **Post date:** [May 16, 2021, 6:37pm UTC](https://community.localwp.com/t/import-failed/24379/5 "2021-05-16T18:37:14Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.