# Local site import database error

**URL:** <https://community.localwp.com/t/local-site-import-database-error/17214>\
**Category:** Support\
**Created:** [February 11, 2020, 11:25am UTC](https://community.localwp.com/t/local-site-import-database-error/17214 "2020-02-11T11:25:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adverset.matt](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@adverset.matt](https://community.localwp.com/u/adverset.matt)\
**Post date:** [February 11, 2020, 11:25am UTC](https://community.localwp.com/t/local-site-import-database-error/17214/1 "2020-02-11T11:25:48Z")

</div>

Hi. I’ve got an existing Wordpress site that’s been developed locally in MAMP Pro. As per instructions I’ve zipped a folder containing the exported database and the wp-content folder and dropped this onto the Local app. Begins to import but then fails – I’ve attached a screenshot of the error which is related to the database. I’ve changed the site url it mentions in lines 1 & 2 of the wp\_options entry to match the name of the site Local launches but doesn’t make a difference. Not sure how to get around this? Any ideas?

 ![Screenshot 2020-02-11 at 10.51.36](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/4/4c6d7c19f3254cf39a716f8af0cb58510033e63d.jpeg)

---

<div class="post-metadata">

**Author:** ![mranderson](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/mranderson/32/9621_2.png) [@mranderson](https://community.localwp.com/u/mranderson)\
**Post date:** [February 11, 2020, 6:40pm UTC](https://community.localwp.com/t/local-site-import-database-error/17214/2 "2020-02-11T18:40:38Z")

</div>

If MAMP is running, you might want to quit the program because I have noticed that if Docker desktop is running then Local will try to use that socket instead of Local’s own socket which is located on my system under:  
`/Users/spencer/Library/Application\ Support/Local/run/RXNPLVqZ7/mysql/mysql.sock`

Can you also check your logs at this location while trying to import the file?  
My workflow is to tail this log while importing so I can see what’s output. Change `spencer` to your Mac’s user.

```auto
tail -f /Users/spencer/Library/Logs/local-lightning.log

```

---

<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:** [May 11, 2020, 6:42pm UTC](https://community.localwp.com/t/local-site-import-database-error/17214/3 "2020-05-11T18:42:05Z")

</div>

Closed on May 11, 2020, 6:42pm UTC

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