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
too.

Vadali



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.


Mime
View raw message