Re: [h2] Make backup relative to the current location

['Christoph Läubrich' via H2 Database]

Thanks that works like a charm :-)

Am 14.05.21 um 11:42 schrieb Noel Grandin:



On 2021/05/13 8:07 pm, 'Christoph Läubrich' via H2 Database wrote:
I'm writing an upgrade script and like to make a backup from withing 
thatscript.


Is it possible to get the name of the current database location to use 
for something like this:




DATABASE_PATH() is the function you want:

http://h2database.com/html/functions.html#database_path





--
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/4e090bea-269f-2f07-0126-72d5f654b517%40googlemail.com.

Re: [h2] Make backup relative to the current location

[Noel Grandin]

On 2021/05/13 8:07 pm, 'Christoph Läubrich' via H2 Database wrote:

I'm writing an upgrade script and like to make a backup from withing that 
script.

Is it possible to get the name of the current database location to use for 
something like this:



DATABASE_PATH() is the function you want:

http://h2database.com/html/functions.html#database_path



--
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/16273586-f095-5170-c4fb-099be0cf7759%40gmail.com.

[h2] Make backup relative to the current location

['Christoph Läubrich' via H2 Database]

I'm writing an upgrade script and like to make a backup from withing 
that script.


Is it possible to get the name of the current database location to use 
for something like this:


BACKUP TO ${current-database-location}.bak


so if my current url is 'jdbc:h2:~/maydatabase' a backup is 
~/maydatabase.db.bak


--
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/d5d069c1-e08e-2b0a-4b47-df6ecd2241ec%40googlemail.com.