# SQL Import Error

**URL:** <https://community.localwp.com/t/sql-import-error/34788>\
**Category:** Support\
**Created:** [December 17, 2022, 2:13pm UTC](https://community.localwp.com/t/sql-import-error/34788 "2022-12-17T14:13:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tobias](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/tobias/32/17331_2.png) [@Tobias](https://community.localwp.com/u/Tobias)\
**Post date:** [December 17, 2022, 2:13pm UTC](https://community.localwp.com/t/sql-import-error/34788/1 "2022-12-17T14:13:44Z")

</div>

I try to import a Wordpress installation. I followed all steps but get the error:

“Uh-oh! Unable to import site.  
Error: Command failed:  
C:\Users\Tobias\AppData\Local\Programs\Local\resources\extraresources\light…\mysql.exe 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”

![error message](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/3X/8/9/89cccdd61d06fe45a8fccfe0bbcc3b1dc1d8eaca.png)

What does this error mean?

---

<div class="post-metadata">

**Author:** ![Nick-B](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/nick-b/32/16140_2.png) [@Nick-B](https://community.localwp.com/u/Nick-B)\
**Post date:** [December 17, 2022, 5:30pm UTC](https://community.localwp.com/t/sql-import-error/34788/2 "2022-12-17T17:30:13Z")

</div>

Hi @Tobias! Nick here following up on your support request!

We would be happy to assist with Local troubleshooting. First, could you help us with some details to assist in our investigation?

- Where did this site originate from?

- What OS and OS version is your computer using?

- What version of Local are you currently using?

- Please attach a copy of your Local logs (how to grab those: [How do I retrieve Local's log file? - FAQ - Local Community](https://local.getflywheel.com/community/t/how-do-i-retrieve-locals-log-file/))

Let us know and we’d be happy to help further!

---

<div class="post-metadata">

**Author:** ![Tobias](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/tobias/32/17331_2.png) [@Tobias](https://community.localwp.com/u/Tobias)\
**Post date:** [December 17, 2022, 6:48pm UTC](https://community.localwp.com/t/sql-import-error/34788/3 "2022-12-17T18:48:57Z")

</div>

Hi Nick,  
thanks for taking of care my request.  
This site originated from a local installation from an XAMP-Setting (Database-Server MariaDB 10.4.14) , Webserver Apache 2.4.54, PHP 7.433

Log is attached  
[local-lightning.log](https://community.localwp.com/uploads/short-url/y4noOYivhNc4m3hTV74tZnA3KCR.log) (74.8 KB)

Operating System: Windows 10  
Local Version 6.6.0+6231

Thanks for your help! Btw: I realized that the installation process worked if I renamed table wp\_options to options. But it only made the error disappear during installation. Site was broke afterwards.

---

<div class="post-metadata">

**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:** [December 16, 2024, 2:13pm UTC](https://community.localwp.com/t/sql-import-error/34788/4 "2024-12-16T14:13:56Z")

</div>

This topic was automatically closed after 730 days. New replies are no longer allowed.