Re: deleting a corrupted database with invalid checksum on page

2014-03-10 Thread Myrna van Lunteren
Perhaps there is something that can help you on this page:
https://wiki.apache.org/db-derby/DatabaseCorruption

HTH
Myrna


On Mon, Mar 10, 2014 at 8:18 AM, EagleS  wrote:

> I can't do rename table either unfortunately. Whatever query I try to run
> I get the same error and hex dump.
>
> - Reply message -
> From: "Bryan Pendleton-3 [via Apache Database]" <[hidden 
> email]<http://user/SendEmail.jtp?type=node&node=137791&i=0>
> >
> To: "EagleS" <[hidden 
> email]<http://user/SendEmail.jtp?type=node&node=137791&i=1>
> >
> Subject: deleting a corrupted database with invalid checksum on page
> Date: Mon, Mar 10, 2014 14:55
>
> > What can I do to just delete this table and then rebuild it from the
> Mirror
> > file?
>
> Can you use RENAME TABLE?
>
> Then you can create your new table with the old name, and just
> leave that old, damaged table around.
>
> Of course, you'll want to arrange a more long-term solution,
> but that might get you back on your feet again while you
> build a more solid overall plan.
>
> bryan
>
>
>
> --
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137789.html
>  To unsubscribe from deleting a corrupted database with invalid checksum
> on page, click here.
> NAML<http://apache-database.10148.n7.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
> --
> View this message in context: Re: deleting a corrupted database with
> invalid checksum on 
> page<http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137791.html>
>
> Sent from the Apache Derby Users mailing list 
> archive<http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html>at
>  Nabble.com.
>


Re: deleting a corrupted database with invalid checksum on page

2014-03-10 Thread EagleS
I can't do rename table either unfortunately. Whatever query I try to run I get 
the same error and hex dump.

- Reply message -
From: "Bryan Pendleton-3 [via Apache Database]" 

To: "EagleS" 
Subject: deleting a corrupted database with invalid checksum on page
Date: Mon, Mar 10, 2014 14:55

> What can I do to just delete this table and then rebuild it from the Mirror
> file?
Can you use RENAME TABLE?
Then you can create your new table with the old name, and just
leave that old, damaged table around.
Of course, you'll want to arrange a more long-term solution,
but that might get you back on your feet again while you
build a more solid overall plan.
bryan









If you reply to this email, your message will be added to the discussion below:

http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137789.html




To unsubscribe from deleting a corrupted database with invalid checksum on 
page, click here.
NAML



--
View this message in context: 
http://apache-database.10148.n7.nabble.com/deleting-a-corrupted-database-with-invalid-checksum-on-page-tp137773p137791.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: deleting a corrupted database with invalid checksum on page

2014-03-10 Thread Bryan Pendleton

What can I do to just delete this table and then rebuild it from the Mirror
file?


Can you use RENAME TABLE?

Then you can create your new table with the old name, and just
leave that old, damaged table around.

Of course, you'll want to arrange a more long-term solution,
but that might get you back on your feet again while you
build a more solid overall plan.

bryan