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. > > Does anyone have a suggestion?
I could not see that anyone else had answered your question. Appologies if I missed it. Not sure I understand the distinction between "existent data" and the whole database. Are you expecting the backup to be smaller than your database? I don't think there is any automatic compression of the backup image so unless you compress the backup yourself it will be the same size as the database. I don't think Derby supports incremental backups, so each new backup will have roughly the same size. The size of each backup image may be reduced if you compress your tables before making the backup, (see the manual). -- dt
