Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 308C19DE4 for ; Fri, 18 Nov 2011 16:28:41 +0000 (UTC) Received: (qmail 78995 invoked by uid 500); 18 Nov 2011 16:28:40 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 78945 invoked by uid 500); 18 Nov 2011 16:28:40 -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 78938 invoked by uid 99); 18 Nov 2011 16:28:40 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Nov 2011 16:28:39 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [85.214.47.106] (HELO h1652951.stratoserver.net) (85.214.47.106) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Nov 2011 16:28:32 +0000 Received: from [192.168.0.3] (host-091-097-140-074.ewe-ip-backbone.de [91.97.140.74]) by h1652951.stratoserver.net (Postfix) with ESMTPA id 885445021C8 for ; Fri, 18 Nov 2011 17:28:09 +0100 (CET) Message-ID: <4EC68836.2030005@spezifikum.com> Date: Fri, 18 Nov 2011 17:30:46 +0100 From: Spezifikum User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: Derby Discussion Subject: Live backup - best practice? Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit Hi, i am quite sure that this question was already asked more than once, but i can't find valuable information. I have a servlet using Apache Derby embedded as a DB backend and have to make daily backups. I can not shut down the entire DB or servlet, so my plan would be to lock the tables and do something like "select into outfile" if possible. Is that a good idea? I expect the database to grow by 50MB per Year, possibly less, but no more than 100MB. It is running on quite powerfull hardware (quad-core, 4GB RAM) and i have a several hours time to do a backup (from 2 to 5 o clock). So performance is not the problem but consistency. Thanks a lot for any comments in advance M. M�ller