main logo
Subject: corrupt database
Author: Elizabeth Robar
Posted: 2003/01/31 16:23:00
 
View Entire Thread
New Search


Hello, all,

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!

So, first question: is there any way I can retrieve the data I've lost
access to? 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!

Thanks in advance,
Liz

_______________________________________________
Valentina mailing list
Valentina (AT) lists .DOT macserve.net
http://listserv.macserve.net/mailman/listinfo/valentina


 
©2003 Elizabeth Robar
<-- Prior Message New Search Next Message -->