You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2009/06/12 20:32:07 UTC

[jira] Commented: (DERBY-1648) Create a tool for salvaging data from a database that will not boot.

    [ https://issues.apache.org/jira/browse/DERBY-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718934#action_12718934 ] 

Kathey Marsden commented on DERBY-1648:
---------------------------------------

There was a thread on derby-user with a proposed alternate solution to this problem which might recover more data and in a more consistent state.  The idea is to provide a property which allows users to skip problematic log records so they can boot and then drop the offending index or table.

http://www.nabble.com/Repairing-a-corrupted-database-with-invalid-checksum-on-page-td23956934.html#a23956934

> 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: 10.1.3.1
>            Reporter: Kathey Marsden
>
> 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.