Database loss

[jetag]

Hi,

 

I had a bunch of processwire site for try install locally on my mac with MAMP. Since an update of MAMP or macOS it seems that all my database have disapear, I didn't find them in phpMyAdmin.

Is there a way to recover my sites? 

Now everytime I try to open one I have this error:

Oops… Error: Exception: SQLSTATE[HY000] [1049] Unknown database 'cotaweb' (in wire/core/ProcessWire.php line 494)

#0 wire/core/ProcessWire.php (302): ProcessWire->load(Object(Config))
#1 index.php (52): ProcessWire->__construct(Object(Config))
#2 {main}

This error message was shown because: site is in debug mode. ($config->debug = true; => site/config.php). Error has been logged.

I have a decade of work there, I'll really appreciate all the help I can have.

thanks

[AndZyk]

Hi @jetag,

you could look here if there is still something:

Quote

Your MAMP PRO MySQL database data is located in “/Library/Application Support/appsolute/MAMP PRO/db/mysql57”.

Source: https://documentation.mamp.info/en/MAMP-PRO-Mac/Servers-and-Services/MySQL/

This folder is hidden, so you would have to use for example your terminal:

open /Library/Application\ Support/appsolute/MAMP\ PRO/db/

If you have a TimeMachine backup, you could restore the folder from your backup.

Regards, Andreas

[jetag]

Many thanks AndZyk, was able to retrieve the important.