Importing site error

Support
1

Issue Summary

I ran into this error while attempting to import my Wordpress site to my local application

Error on local
Error: Command failed: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+5/bin/darwin/bin/mysql local -B —disable-column-names -e SELECT option_value FROM options WHERE option_name = ‘siteurl’;
ERROR 1146 (42S02) at line 1: Table ‘local.options’ doesn’t exist

Troubleshooting Questions

I attempted to create a zip file with just the wp content and not include the .sql file: I then received this:
Error: Local was unable to import the following SQL files:

  • Are you able to create a new, plain WordPress site in Local and access it in a Browser?
    Yes

Replication

System Details

  • Which version of Local is being used?
    5.10.3 (just downloaded it)

  • What Operating System (OS) and OS version is being used?
    MacBook Pro 11.2.3

Thanks

2

I have the same issue. Happens both with 5.10.3 and 5.10.4. The database file was exported with phpadmin. I had another local site that was set up manually, I tried deleting so localwp was clean and then importing, thinking there may be a conflict, but this made no difference, same error.

Error: Command failed: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+5/bin/darwin/bin/mysql
local -B --disable-column-names -e SELECT option_value FROM wp_8nrns8options WHERE option_name = ‘siteurl’;

The sql file DOES contain the expected

CREATE TABLE wp_8nrns8options (
option_id bigint(20) UNSIGNED NOT NULL,
option_name varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ‘’,
option_value longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
autoload varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ‘yes’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

and the fields DOES contain siteurl

INSERT INTO wp_8nrns8options (option_id, option_name, option_value, autoload) VALUES
(1, ‘siteurl’, ‘https://www.redacted.studio’, ‘yes’),
(2, ‘home’, ‘https://www.redacted.studio’, ‘yes’),
(3, ‘blogname’, ‘Just another WordPress site’, ‘yes’),

3

SOLUTION FOUND. Per this post Unable to Import Wordpress Site to Local 5.10.1 - ERROR 1146 (42S02) at line 1: Table 'local.wp_options' doesn't exist

Use a text editor to comment out the two lines in the SQL file like this (add the two hypnens)

– CREATE DATABASE …
– USE `…

4

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