corrupt database

[Elizabeth Robar]

I know it sounds strange - to have a good database, then issue a SELECT 
(Read) statement, and have it croak - but I've even reproduced it!  My 
(uneducated, wild) guess is that the system table sysitems didn't like 
it somehow... whereas a normal, user-defined table might not have taken 
it so poorly.

Unfortunately, I was using one-file mode - so the below method won't 
help in restoring the data.  I did have a backup, so it's not 
essential... but I'm interested in possible restoration methods for the 
future.  Along with development, I'm doing a lot of manual input, and I 
only make copies every so often... maybe I'll increase the frequency.

Thanks, though!
Liz

On Friday, January 31, 2003, at 04:49  PM, Ruslan Zasukhin wrote:

> on 1/31/03 11:32 PM, Elizabeth Robar at erobar at earthlink.net wrote:
>
> Hi Elizabeth,
>
> :-)
>
> Just only I have told on RB list that it is hard to corrupt Valentina 
> db,
> And Ops...
>
>> Take a database (mine has about 6 tables and WAS working beautifully),
>> and in ViSQL Carbon run the statement
>
>> SELECT * FROM sysitem WHERE Value<>0
>
>> (I was trying to figure out how to return all the fields in a given
>> table so I could write some scripts more easily)
>> ViSQL Carbon crashes mightily, and the sysitem table seems to be wiped
>> out... making all the data in the database inaccessible!
>
> In fact this sounds strange.
>
> So you have had some GOOD DB with data,
> You open it in viSQL,
> and you do query and READ data.
>
> You cannot corrupt db if you DO NOT WRITE data into db file...
>
>> So, first question: is there any way I can retrieve the data I've lost
>> access to?
>
> 1) do you have 4 files mode in db ?
> Try move .vdb file into separate folder and open in VAPP.
> If this works then vdb is okay
>
> 2) try now open vdb + .dat
> If this also fine then problem in .ind
>
>> And what basic things ought I to know, so I don't do something so 
>> disastrous
>> again?  I hope this is more than just a lesson in the importance of 
>> backups!
>
> Yes backups are important if you have important data.
>
> I don't know how you get corruption in this case.
> If you READ then no way for corruption.
>
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://listserv.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>