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