db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vadali <shlomivak...@gmail.com>
Subject Re: backing up the DB
Date Wed, 18 Aug 2010 11:35:01 GMT

Hey Dag,
Thank you for your reply :)

I ended up solving it by 
http://db.apache.org/derby/docs/10.4/tools/ctoolsimport16245.html using the
bulk import and export procedures .

VTI seems really interesting, thank you for pointing this one out for me


Dag H. Wanvik-2 wrote:
> vadali <shlomivaknin@gmail.com> writes:
>> Hi Kristian, Thank you for your reply
>> The db can be off when i back it up. I am unfamiliar with any compress
>> routines.. any pointers would be helpful. 
> Have a look here:
> http://db.apache.org/derby/docs/10.4/adminguide/cadminspace21579.html
> http://db.apache.org/derby/docs/10.6/ref/rrefaltertablecompress.html
>> I dont really mind how the filtering is done (up front or on the backup
>> copy), i just dont want it to be too long. 
>> my main goal is to burn the directory onto a cd or dvd, but since it can
>> easily exceed the size of a single media, i tar it, slice it to multiple
>> files of fixed sizes, and burn each on a different media (quite a
>> lengthly
>> process..), where later i could reattach the files, untar it, load up a
>> db
>> onto this folder, and query all i want :)
>> I am not so sure what a VTI is, or how to write such a script that will
>> do a
>> sort of a database copy..
> VTIs are described here:
> http://db.apache.org/derby/docs/10.6/devguide/cdevspecialtabfuncs.html
> Dag

View this message in context: http://old.nabble.com/backing-up-the-DB-tp29324036p29470258.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message