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 <[email protected]> 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.
