Import failed

Support
1

Issue Summary

My original site is 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” 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 :slight_smile:

“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 (60.4 KB)

Source site downloaded to my SITES folder in subfolder VISIONS OFHEAVEN

2

The only files you need to include in the zip is the wp-content folder.

3

Hey @spirittlk – That specific error:

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:

4

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 :slight_smile:

5

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