db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: backing up the DB
Date Tue, 17 Aug 2010 21:42:11 GMT
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

Mime
View raw message