Re: [h2] Create an SQL to copy all from H2 database in geonetork

[Andreas Reichel]

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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/894a39861b872988fb09c0928a67ebc3ba7fe90c.camel%40manticore-projects.com.

Re: [h2] Create an SQL to copy all from H2 database in geonetork

[xavi rayo]

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 h2-database...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/h2-database/f392abc9-f1e2-4c41-a02a-058982219e8bn%40googlegroups.com
>>  
>> 
>> .
>>
>>
>>

-- 
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/1cfdae37-4f63-4e48-a8ed-8649eead32ban%40googlegroups.com.

Re: [h2] Create an SQL to copy all from H2 database in geonetork

[xavi rayo]

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 h2-database...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/h2-database/f392abc9-f1e2-4c41-a02a-058982219e8bn%40googlegroups.com
>  
> 
> .
>
>
>

-- 
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/10115b52-903a-4b40-b8ca-ba07023a3076n%40googlegroups.com.