# Where's the SQL file located exactly?

**URL:** <https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427>\
**Category:** Support\
**Created:** [August 1, 2017, 11:28pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427 "2017-08-01T23:28:56Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![barkins](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/barkins/32/4937_2.png) [@barkins](https://community.localwp.com/u/barkins)\
**Post date:** [August 1, 2017, 11:28pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/1 "2017-08-01T23:28:56Z")

</div>

Trying out Local for the first time. I installed a local WordPress site on my Dropbox account so that I can perhaps sync a website via Dropbox between multiple computers.

Having said that, where’s the actual SQL database for the WordPress site installed being saved in? Is there a folder for it I can access somewhere, ideally include it in my Dropbox folder somehow.

Apologies if this was already discussed. Thanks

---

<div class="post-metadata">

**Author:** ![clay](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/clay/32/8248_2.png) [@clay](https://community.localwp.com/u/clay)\
**Post date:** [August 2, 2017, 2:45pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/2 "2017-08-02T14:45:30Z")

</div>

Hi @barkins,

SQL files will automatically dump into `app/sql` whenever a site is stopped or restarted.

As far as the raw SQL data goes, it’s stored inside the container in `/var/lib/mysql`.

To sync Local websites with Dropbox, see [Using Local on multiple computers](https://local.getflywheel.com/community/t/using-local-on-multiple-computers/345/17?u=clay)

---

<div class="post-metadata">

**Author:** ![Antonios](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/antonios/32/8449_2.png) [@Antonios](https://community.localwp.com/u/Antonios)\
**Post date:** [September 24, 2019, 12:46pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/3 "2019-09-24T12:46:58Z")

</div>

I am having the same issue, and the files are not in `app/sql`. there is not a folder called `sql` in the `app` folder. I am running Linux Mint 19.2.

---

<div class="post-metadata">

**Author:** ![jkiley](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/jkiley/32/7719_2.png) [@jkiley](https://community.localwp.com/u/jkiley)\
**Post date:** [September 24, 2019, 5:21pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/4 "2019-09-24T17:21:31Z")

</div>

Hey @Antonios

Local Lightning _(the Linux version is a part of that)_ is still currently in public beta. The feature of exporting SQL files to `/app/sql` on close isn’t currently available but will be in a future release.

In the meantime, you can right-click on the site name and export the site. This will have a copy of the database in it.

**Pro Tip** If you put only `*` in the File Exclusion Filter, this will only export the database and export much faster.

 ![26%20AM](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/f/f757b0ab556b6b310713fb7c3aaa9ac61303f355.png)

---

<div class="post-metadata">

**Author:** ![renWeb](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renWeb](https://community.localwp.com/u/renWeb)\
**Post date:** [September 24, 2019, 5:56pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/5 "2019-09-24T17:56:04Z")

</div>

Same issue here using Local Lightning on Win 7. There doesn’t seem to be a link to Adminer any more but I need to access the DB data to fix a broken site.

Do I need to install Adminer (or PHPMyAdmin) on the machine to access the data used by LL? Thanks.

---

<div class="post-metadata">

**Author:** ![jkiley](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/jkiley/32/7719_2.png) [@jkiley](https://community.localwp.com/u/jkiley)\
**Post date:** [September 24, 2019, 6:01pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/6 "2019-09-24T18:01:35Z")

</div>

Hey @renWeb,

Adminer isn’t in the Local Lighten public beta quite yet. As an alternative, you can setup TablePress to access the database.

We have a help doc on that right here:

> **[How to Use TablePlus with Local](https://getflywheel.com/wordpress-support/how-to-use-tableplus-with-local/)**
>
> Flywheel offers expert WordPress support at no charge. We also have a lot of answers to common questions. Dive into our help section for easy answers.

---

<div class="post-metadata">

**Author:** ![renWeb](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renWeb](https://community.localwp.com/u/renWeb)\
**Post date:** [September 24, 2019, 6:02pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/7 "2019-09-24T18:02:02Z")

</div>

Aha - found this…

[https://localbyflywheel.com/community/t/phpmyadmin-adminer-didnt-show-up/14187](https://localbyflywheel.com/community/t/phpmyadmin-adminer-didnt-show-up/14187)

---

<div class="post-metadata">

**Author:** ![renWeb](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renWeb](https://community.localwp.com/u/renWeb)\
**Post date:** [September 24, 2019, 6:02pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/8 "2019-09-24T18:02:44Z")

</div>

That was quick! - Thanks 🙂

Edit:  
I installed TablePlus and am now back up and running.

NB. Instructions on the ‘how-to-use-tableplus-with-local’ page have changed slightly - now using a port rather than a socket - but seems to work well and very intuitively (+ has a cool dark theme). Just remember to hit Ctrl-s, or edit\>commit, to save changes before you go 🙂

BTW. I like the way Local (Lightning) is shaping up - can’t imagine going back to using VirtualHost now! Best wishes, Ren

---

<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:** [August 25, 2020, 6:32pm UTC](https://community.localwp.com/t/wheres-the-sql-file-located-exactly/2427/9 "2020-08-25T18:32:23Z")

</div>


