From derby-user-return-13522-apmail-db-derby-user-archive=db.apache.org@db.apache.org Sun Apr 10 20:31:09 2011 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 55838 invoked from network); 10 Apr 2011 20:31:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Apr 2011 20:31:09 -0000 Received: (qmail 13433 invoked by uid 500); 10 Apr 2011 20:31:08 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 13410 invoked by uid 500); 10 Apr 2011 20:31:08 -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 13403 invoked by uid 99); 10 Apr 2011 20:31:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Apr 2011 20:31:08 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of peter.ondruska@gmail.com designates 74.125.83.44 as permitted sender) Received: from [74.125.83.44] (HELO mail-gw0-f44.google.com) (74.125.83.44) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Apr 2011 20:31:02 +0000 Received: by gwb20 with SMTP id 20so2180413gwb.31 for ; Sun, 10 Apr 2011 13:30:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=UxUV0E3NamW66m5T0jlLT8LbPHnxXaGhTItzfcuBzMM=; b=vv2Jgra7a/IljYyT2tozGGXfdD6GIs2IaHwzwDTgqs3IpEFIf3FMJYZDjXoMpvk3ih U9jGBtxNegIsTRBxGabc6qHClKDe4law+g7vxpeowsibvjfReYlCEJ2KnAzJUZabhGgI UQap8ZCOoZAcf79DoSVm5BL9RlvKCxhqB1Ir0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=qkISAwDjoueP5DtXKuGiL5NTDwe6AazL/+k0zacuFHGW4p0zGXe3P8Cg7LjA8FpvYr /6PUSUtAsgGXqVjknfeYET5kxgqesIdApK1N18QV53J3Lefv7GPdSswLygHs5qgq3fLE Zcm6sVx7llRdIS344wSeoyYoKiJTY90+6n6nE= MIME-Version: 1.0 Received: by 10.236.77.138 with SMTP id d10mr5709928yhe.110.1302467441704; Sun, 10 Apr 2011 13:30:41 -0700 (PDT) Received: by 10.147.170.3 with HTTP; Sun, 10 Apr 2011 13:30:41 -0700 (PDT) In-Reply-To: References: Date: Sun, 10 Apr 2011 22:30:41 +0200 Message-ID: Subject: Re: How Portable are Derby-managed data? From: =?UTF-8?Q?Peter_Ondru=C5=A1ka?= To: Derby Discussion Content-Type: text/plain; charset=UTF-8 http://db.apache.org/derby/docs/10.7/adminguide/cadminhubbkup63476.html On Thu, Apr 7, 2011 at 5:59 AM, niloofar montazeri wrote: > Hi, > > I am a MySql user and am searching for a light-weight database system that > allows me to easily move tables from one machine to another. My problem with > MySql was that in order to move data from machine m1 to machine m2, I needed > to stop the server on m2, move the entire data folder (i.e., all the > databases and tables) from m1 to m2 and then restart the server on m2 (If I > was lucky and it would easily restart). > Maybe I am not familiar with correct MySql settings, but I need an easy to > install tool for sorting, counting, indexing and merging data that allows > for high portability. Is Derby the right tool for this purpose? > > I appreciate your help... > Niloofar > -- Peter