Solved

Goldmine over BDE - mailbox too large - how to pare down?

Posted on 2006-11-13
5
591 Views
Last Modified: 2012-06-27
Got a client running Goldmine on the included BDE database engine.  Their mailbox database memo file is nearly 2GB and needs to be pared down.  What tool can I use to get into that database (including the monster memo file) and archive off about half of the records?

I tried using FoxPro, MS Access with an ODBC connector - nothing seems to work.  Any tips?

Thanks in advance!
0
Comment
Question by:ejbman
  • 2
5 Comments
 
LVL 31

Expert Comment

by:moorhouselondon
ID: 17931970
There should be some *.?DX files in the data directory.  What extension are these files?  If MDX then try Dbase4.
0
 
LVL 1

Author Comment

by:ejbman
ID: 17945205
moorhouselondon,

I try that through Access and even though a massive .fpt files is there, it give me "Cannot locate the requested Xbase memo file."

any other thoughts?
0
 
LVL 31

Accepted Solution

by:
moorhouselondon earned 500 total points
ID: 17948558
.fpt is a FoxPro file.

You need to investigate recovery tools.  The only issue you may have is if Goldmine have changed the Memo Header structure so that standard tools such as these will fail (it's not that the wouldn't want you to recover your data, but by recovering data in an unauthorized way may screw up something fundamental in GoldMine - for instance, endangering Referential Integrity).

http://fox.wikis.com/wc.dll?Wiki~TableCorruptionRepairTools~VFP

Take backup copies first!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question