Paul, one other thing:
When you did the UNLOAD you created two output files. If you still have them
(or can easily re-create them) did/can you check the non-LOB extension one
to see if the missing rows are in it? If you did and they are there you
ought to be able to extract them into a much smaller file and then edit that
into a format to append to your clean database.
Regards,
Alastair.
----- Original Message -----
From: "Alastair Burr" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 11, 2009 8:08 AM
Subject: [RBASE-L] - Re: Life in RScope
That's a shame. I take it that you don't have a backup that does contains
the rows that are now missing? If you do and there are only 7 can you
manually enter them to the database created by the RELOAD?
Alternatively, if you can see them in the database with the errors using
R:Scope can you manually re-enter them in the RELOADed database?
Regards,
Alastair.
----- Original Message -----
From: "Paul InterlockInfo" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 11, 2009 1:14 AM
Subject: [RBASE-L] - Re: Life in RScope
Tried that just now. No luck! Same row count 11,104 :(
I do see the 7 deleted rows in RScope and have left them alone, just
empty
mistakes by the user and they deleted them (that is Ok!) but the missing
rows that are there are the pain. I can view them and Rscope allows me
to
read them.
Reminds me of golf - I can see the hole but ......... it's just getting
there.
Sincerely,
Paul
I believe this was all about the same I lost that NAS. Right about the
same
day 6-9-09 Might there be a connection-? Hard to say.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Alastair
Burr
Sent: Wednesday, June 10, 2009 7:17 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Life in RScope
Forgive me, but I think you are mixing up two alternatives:
"UNLOAD then LOAD" is not the same thing as "RELOAD" - although you
should
end up with the same thing (with an error-free database).
Nevertheless, using RELOAD a new database is created and the indexes
rebuilt
in one go, and, more often than not, I have retrieved data this way when
others have failed. You will still see error messages but ignore them if
the
process will continue. (You can always go back to your original db.)
You would also expect different row counts if you delete rows during the
course of using your data.
Obviously, it's up to you, but try it and see if you are truly missing
anything in the new db.
Regards,
Alastair.
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.60/2166 - Release Date: 06/09/09
18:08:00
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.60/2166 - Release Date: 06/09/09
18:08:00
