Restore a deleted database

Question

Mistakenly, I deleted the recent database I was working on. I can find the folders saved under "C:\Users\{Username}\openLCA-data-1.4\databases" however I cannot import the database folder to OpenLCA as it is not stored as zolca format. How can I import the saved database folder to OpenLCA? 

Thank you 

Basak

Answer 1

Hm, when you delete a database from the openLCA UI, also the phyiscal files in the directory are removed. If you can restore these, or have these still, then you can make it "visible" again in openLCA by modifying a databases.json text file that you find on top of the databases folder. Make a backup of this, then open in a text editor. It looks like this:

insert the name of the database you miss, in the same "curly bracket structure", under local databases, then save and restart openLCA.

Good luck!

Andreas

Comments

Thank you Andreas. I could follow your instructions and found all the databases in text editor. However, for some reason, I lost the database folder under C:\Users\{Username}\openLCA-data-1.4\databases that I was trying to restore.

---

Yes, I guessed that since you deleted the database via the openLCA UI. Then, ideally, you have a backup..

---

Good afternoon, I accidentaly moved the folder where the database, products, flows and product systems that I was working on were saved.  
I followed this instructions and I was able to restore the database, but inside it I can find only the product systems I created, and the processes and flows from Ecoinvent, but the processes and flows I created were not restored.

Where does OpenLCA save the processes and flows we create? Is there a way to restore them in this case?

Many thanks in advance for your support,
I will be available for further explanations.

Cristina