Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
using an old BLB file |
Wed, Aug 2 2006 6:44 AM | Permanent Link |
Jerry Blumenthal | One of my users had some kind of data corruption that trashed part of a
blb file, so that much of it was missing after the dbisamtable.repair finished. His last backup was two months ago. My app actually makes automatic backups every day by copying to a BUMonday or BUTuesday etc. folder, and I have preserved these on his hard disk so they will not get overwritten by current operations. However, when I tried to copy a recent BLB file to his data folder and then did a repair, I got an "Invalid BLOB offset in BLOB file for physical record # 1, error fixed..." message for every record and the BLB file was empty. Is there any way I can use either a recent or the two month old BLB file to retrieve the data and insert it into the current file? DBISAM 2.12 --- it's old but it works for me. TIA, Jerry |
Wed, Aug 2 2006 7:11 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Jerry
The problem will be that the two files will be out of sync. What I can suggest is more work 1. Do a repair on the existing table 2. Restore the table to a separate directory/under a different name 3. Write a bit of Pascal or SQL to update the memo fields from one table to the other Roy Lambert |
Wed, Aug 2 2006 2:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jerry,
<< However, when I tried to copy a recent BLB file to his data folder and then did a repair, I got an "Invalid BLOB offset in BLOB file for physical record # 1, error fixed..." message for every record and the BLB file was empty. Is there any way I can use either a recent or the two month old BLB file to retrieve the data and insert it into the current file? >> Not without dumping the contents of the BLB and re-matching everything by hand. If you want to pursue this avenue, let me know via private email and I'll work out getting a program to you that will dump the BLB into separate files. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |