Where can I find the database files related to a WP-Site created using Local?
Thx in advance
best
Kai
Where can I find the database files related to a WP-Site created using Local?
Thx in advance
best
Kai
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.
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
Thx a lot - this is the first step
I found them
Now I have to figure out how to rebuild everything…
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.