db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Sitsky (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-1648) Create a tool for salvaging data from a database that will not boot.
Date Mon, 15 Jun 2009 05:12:07 GMT

     [ https://issues.apache.org/jira/browse/DERBY-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

David Sitsky updated DERBY-1648:

    Attachment: derby.txt

Here is the patch to the code which I used successfully to fix a corrupted Derby database.
 In this instance, I was lucky, the corruption was on a single page, that was just used by
an index, so there was no data loss.

> Create a tool for salvaging data from a database that will not boot.
> --------------------------------------------------------------------
>                 Key: DERBY-1648
>                 URL: https://issues.apache.org/jira/browse/DERBY-1648
>             Project: Derby
>          Issue Type: New Feature
>          Components: Tools
>    Affects Versions:
>            Reporter: Kathey Marsden
>         Attachments: derby.txt
> If  a Derby database is corrupted  by dual boot or for some other reason, it is really
necessary to create a new database and transfer the data.  Currently there is not a utility
to do this.
> It would be good to have a tool which given a corrupted database would attempt to salvage
the data it can  by creating a new database and transferring the data while preserving the
state of the original corrupted db for analysis

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message