db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Derby Backup
Date Mon, 05 Nov 2007 15:00:01 GMT
Dyre.Tjeldvoll@Sun.COM writes:

> Francisco Trindade <francisco@m3tech.com.br> writes:
>
>> Hi,
>>
>> Im building a system using Apache Derby, and I couldnt find a way to
>> backup the existing data from the database.
>> The only procedure I've found in the documentation is to create a
>> online/offline backup, that copies the existent database to a
>> different location.
>> The problem with this approach is that the backup file becomes very
>> large (15 - 30 MB) in my case, and that's because Im zipping the
>> database after copying it.
>>
>> I was wondering if it doesn't exist a way to create a backup only of
>> the existent data, and not the whole database, like a dump.

Another approach might be to export just the data of the user tables,
cf. see the SYSCS_UTIL.SYSCS_{EXPORT,IMPORT}_* system procedures in
http://db.apache.org/derby/docs/10.3/ref/crefsqlbuiltinsystemprocedures.html
and http://db.apache.org/derby/docs/10.3/tools/ctoolsimport16245.html

The schema can be dumped for recreation using dblook:
http://db.apache.org/derby/docs/10.3/tools/ctoolsdblook.html

Thanks,
Dag

Mime
View raw message