Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 11399 invoked from network); 25 Aug 2005 00:06:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Aug 2005 00:06:38 -0000 Received: (qmail 34993 invoked by uid 500); 25 Aug 2005 00:06:37 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 34963 invoked by uid 500); 25 Aug 2005 00:06:36 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 34947 invoked by uid 99); 25 Aug 2005 00:06:36 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2005 17:06:36 -0700 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: 32.97.110.129 is neither permitted nor denied by domain of suresh.thalamati@gmail.com) Received: from [32.97.110.129] (HELO e31.co.us.ibm.com) (32.97.110.129) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2005 17:06:53 -0700 Received: from westrelay02.boulder.ibm.com (westrelay02.boulder.ibm.com [9.17.195.11]) by e31.co.us.ibm.com (8.12.10/8.12.9) with ESMTP id j7P06VF3320382 for ; Wed, 24 Aug 2005 20:06:31 -0400 Received: from d03av01.boulder.ibm.com (d03av01.boulder.ibm.com [9.17.195.167]) by westrelay02.boulder.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j7P05wen529552 for ; Wed, 24 Aug 2005 18:05:59 -0600 Received: from d03av01.boulder.ibm.com (loopback [127.0.0.1]) by d03av01.boulder.ibm.com (8.12.11/8.13.3) with ESMTP id j7P06UqL014504 for ; Wed, 24 Aug 2005 18:06:30 -0600 Received: from [127.0.0.1] (tsuresh.svl.ibm.com [9.30.40.208] (may be forged)) by d03av01.boulder.ibm.com (8.12.11/8.12.11) with ESMTP id j7P06S3o014462 for ; Wed, 24 Aug 2005 18:06:30 -0600 Message-ID: <430D0B81.7050209@gmail.com> Date: Wed, 24 Aug 2005 17:06:25 -0700 From: Suresh Thalamati User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: database backup questions References: <1cbd6f83050820111779a9329a@mail.gmail.com> In-Reply-To: <1cbd6f83050820111779a9329a@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Mag Gam wrote: > Hello derby-users: > > My questions are: > > 1) Is it possible to do an incremental backup for the > derby/cloudscape database? > Where I have a master set, and apply the small increments? Derby has support for roll-forward recovery, using this mechanism if you take backup with log archive log mode enabled, derby keeps all the transaction logs. Using the full backup and the transaction log , one can restore the database to latest state before a failure. Currently, I think there is no support for archiving logs to a backup location. So , Transaction logs have to be stored on a fault-tolerant disk. Derby admin guide has more info under Rollforward section on this topic: http://db.apache.org/derby/docs/10.1/adminguide/ > > 2) Is it possibe to do a SQL text dump of the database? I will need > this so, I can dump the db in text, and compress it using gzip. > I don't think there is such a tool for backup usage. There is debug property (derby.language.logStatementText) todump the SQL Text into the error log for debugging purposes. Derby has export functionality to dump the table to a file, and a dblook toool to dump the schema. Derby backups can compressed using gzip , I don't understand why would u want to dump sql text and then compress. Hope that helps. -suresht