H2 database upload
-
The H2 database is backuped up as a zip file. When the file is unzipped it becomes a SQL file. My question is how do I reupload that database into Mango?
I have an idea, let me know if I am on the right track:
Open the SQL file in Notepad
Save as a json file
Open import/export in Mango
Copy json text into Mango
Import -
The easiest way is on the system setting page under Database Backup Settings:
Click the Get backups button and this will populate the dropdown list of available backups to restore.
-
Thanks, Joel.
Will this also work with the NoSQL database?
-
No, that's only for the H2 database but there is a similar tool for NoSQL depending on what version you have. Its on the NoSQL tab on the main menu but I think this is only in 2.6. You can just unzip the NoSQL database and copy it into the databases folder to replace what is there.