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