[EMAIL PROTECTED] writes:
> Francisco Trindade <[EMAIL PROTECTED]> 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
