Where to find the database files on mac os?

[77of99]

Where can I find the database files related to a WP-Site created using Local?

Thx in advance

best

Kai

[mikel]

@77of99

Have you tried using WP CLI to access and dump/export the local site db wherever you like.

[77of99]

As I desperatly try to rebuild 2 Sites after a HD Crash I have no access to the site.
I have a complete backup of all files of the HD but would have to transfer and reassemble everything by hand.

[mikel]

@77of99

I am not sure if this will help but you should be able to access the raw DB files relative to your home directory. This will not likely match your system exactly but it should be similar:

[10:46:28] nymb012:~$ ls -al ~/Library/"Application Support"/Local/run/9EDun0sW4/mysql/
total 8
drwxr-xr-x   5 mikelking  staff  160 Nov 29 10:45 .
drwxr-xr-x   6 mikelking  staff  192 Jul  7 10:32 ..
drwxr-xr-x  27 mikelking  staff  864 Nov 29 10:45 data
srwxrwxrwx   1 mikelking  staff    0 Nov 29 10:45 mysqld.sock
-rw-------   1 mikelking  staff    6 Nov 29 10:45 mysqld.sock.lock
[10:46:45] nymb012:~$ ls -al ~/Library/"Application Support"/Local/run/9EDun0sW4/mysql/data
total 559256
drwxr-x---   12 mikelking  staff        384 Nov 29 10:45 #innodb_temp
drwxr-xr-x   27 mikelking  staff        864 Nov 29 10:45 .
drwxr-xr-x    5 mikelking  staff        160 Nov 29 10:45 ..
-rw-r-----    1 mikelking  staff         56 Jul  7 10:32 auto.cnf
-rw-r-----    1 mikelking  staff      27460 Nov 29 10:45 binlog.000015
-rw-r-----    1 mikelking  staff         16 Nov 29 10:45 binlog.index
-rw-------    1 mikelking  staff       1680 Jul  7 10:32 ca-key.pem
-rw-r--r--    1 mikelking  staff       1112 Jul  7 10:32 ca.pem
-rw-r--r--    1 mikelking  staff       1112 Jul  7 10:32 client-cert.pem
-rw-------    1 mikelking  staff       1680 Jul  7 10:32 client-key.pem
-rw-r-----    1 mikelking  staff       3642 Oct 25 08:01 ib_buffer_pool
-rw-r-----    1 mikelking  staff  100663296 Nov 29 10:45 ib_logfile0
-rw-r-----    1 mikelking  staff  100663296 Jul  7 10:42 ib_logfile1
-rw-r-----    1 mikelking  staff   12582912 Nov 29 10:45 ibdata1
-rw-r-----    1 mikelking  staff   12582912 Nov 29 10:45 ibtmp1
drwxr-x---  110 mikelking  staff       3520 Jul  7 10:42 local
drwxr-x---    8 mikelking  staff        256 Jul  7 10:32 mysql
-rw-r-----    1 mikelking  staff   25165824 Nov 29 10:45 mysql.ibd
-rw-r-----    1 mikelking  staff          6 Nov 29 10:45 nymb012.haynet.pid
drwxr-x---  105 mikelking  staff       3360 Jul  7 10:32 performance_schema
-rw-------    1 mikelking  staff       1676 Jul  7 10:32 private_key.pem
-rw-r--r--    1 mikelking  staff        452 Jul  7 10:32 public_key.pem
-rw-r--r--    1 mikelking  staff       1112 Jul  7 10:32 server-cert.pem
-rw-------    1 mikelking  staff       1676 Jul  7 10:32 server-key.pem
drwxr-x---    3 mikelking  staff         96 Jul  7 10:32 sys
-rw-r-----    1 mikelking  staff   22020096 Nov 29 10:45 undo_001
-rw-r-----    1 mikelking  staff   12582912 Nov 29 10:45 undo_002

[77of99]

Thx a lot - this is the first step
I found them
Now I have to figure out how to rebuild everything…