Where are LocalWP MySQL databases stored?

Where are LocalWP MySQL databases stored on a Mac?

I have exported 3 websites from WP Engine and dragged their zips into LocalWP to create them locally.

I noticed there were 2 SQL files in each of the site’s sql folders, e.g: /Users/Username/Local Sites/site/app/sql/

If I delete both of those files (to save disk space), the local WordPress websites still load fine.


Hi @s.doig

You’re correct about the location. Here is what mine looks like:

If you delete the SQL files Local will generate a new blank DB for the install when you Start. So yes the site will still open/function. You’ll just want to be careful not to Push a default DB up to WPE and wipe out your Database there if it has necessary content. If however you just created these sites on WPE and then pulled them down so they are effectively new installs, then that isn’t a concern.

Hi @Nick-B,

After deleting all SQL files in the sql folder, all local sites still loaded fine with the original content & settings still present.

Hey @s.doig

I need to clarify a bit here. That /sql folder I showed is where database dumps go. This would be kind of like “checkpoints” or backups from when you start/stop the site in Local (or export) and it makes a new one and puts it there.

When you’re just actively working on the site, the database should live inside the Application Support/Local/run folder.

Great, thanks @Nick-B

1 Like