Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <41A40FBA.9000506@thatone.com>
Date: Tue, 23 Nov 2004 20:36:10 -0800
From: Calvin Smith <calvin@thatone.com>
User-Agent: Mozilla Thunderbird 0.8 (X11/20041014)
MIME-Version: 1.0
To: Calvin Smith <calvin@thatone.com>
Cc: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Unable to restore a Derby database [SOLVED?]
References: <41A28890.1040203@thatone.com> <41A38825.6070909@sbcglobal.net>
 <41A40CDB.1030808@thatone.com>
In-Reply-To: <41A40CDB.1030808@thatone.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Oh man, do I feel stupid. I just re-read the manual again and realized 
that the restore from path is not the directory into which the backup 
occurred, but the sub-directory that the backup created in that directory.

I was doing:

connect 'jdbc:derby:myDb;restoreFrom=/mybackupdir';

instead of:

connect 'jdbc:derby:myDb;restoreFrom=/mybackupdir/myDb';

After trying the second form, it works perfectly. Perhaps a better 
message (indicating success or failure, instead of silence in both 
cases) would be helpful, but this was a case of PEBCAK 
(http://www.hyperdictionary.com/computing/pebcak).

Thanks again, and I apologize for wasting anybody's time on a silly 
problem....

-calvin

p.s. If anybody thinks that the silent response when the backup 
directory (which contains the backup database directory) exists but the 
backup database directory doesn't exist is a bug, I'll be happy to file 
a Jira issue. This is inconsistent with the behavior when the backup 
database directory does exist but isn't valid, and the user is notified 
of an error.