Greetings! First, you NEED to find the location of the Database file in your file- system. It should be stated clearly in the connection URL. When having located this file, you can use the H2 Command Line Tools for Recover/Script or the provided UI Tool to extract the DB into a SQL file. The UI works on any OS including MacOS since it is a Java based application which depends on a JRE 11 only.
Good luck! Andreas On Tue, 2023-05-30 at 02:15 -0700, xavi rayo wrote: > My main problem is that I have de h2.db file but I can't find how to > acces to it > > El dia dimarts, 30 de maig de 2023 a les 11:14:31 UTC+2, xavi rayo va > escriure: > > Hi Andreas, > > thanks a lot for your help! > > I was wondering if there is the possibility to use the user > > interface in a macOs computer or should I use the command line. > > > > Thanks a lot! > > > > El dia dilluns, 29 de maig de 2023 a les 16:02:10 UTC+2, Andreas > > Reichel va escriure: > > > Greetings, > > > > > > you can try "Export to SQL" and/or "Recovery". Both will give you > > > an SQL script which can be used to create a DB afresh. > > > There is command line and I also provide an (unoffical) UI: > > > https://github.com/manticore-projects/H2MigrationTool > > > > > > Good luck! > > > Andreas > > > > > > On Mon, 2023-05-29 at 05:46 -0700, xavi rayo wrote: > > > > Hi all, > > > > I have a geonetwork installation which uses H2 as storage > > > > database. My geonetwork have crashed and can't manage to make > > > > it work again, so before doing a fresh install, I would like > > > > (really need it!) to make a copy of the data of the database. > > > > Any suggestion on how to do it will be really appreciated. > > > > > > > > Thanks a lot! > > > > > > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/894a39861b872988fb09c0928a67ebc3ba7fe90c.camel%40manticore-projects.com.
