How to Repair a Corrupt database
2013-11-08
We have a corrupt database here at New Apostolic Church.

Is there any tool available that we could use to try a repair? Have already done a raw data export, but I get error messages and when reimporting there are records missing and many are incomplete like missing transaction dates, etc.
This answer was correct
Created by14:25 15 Apr 2013

You have 2 options

(1)Revert to a backup before the problem occurred.

(2)Build a new database, and export from the corrupt database the required registers, and import into the new database.
Do not try and run a database that was built from a Raw Dump.

You do not say how the database became corrupt?
If it was because of disk space, then you will have to restore to a good version. The reason for this, is that part of the database would have been in cache memory, and since there was no disk space available, the data in memory would have been lost.

If you are using Database Journaling, then take the last good copy of the database, and apply the journal.This will bring up to the point where the crash occurred.

HansaWorld Support Team
This answer was correct
2013-04-15

You have 2 options

(1)Revert to a backup before the problem occurred.

(2)Build a new database, and export from the corrupt database the required registers, and import into the new database.
Do not try and run a database that was built from a Raw Dump.

You do not say how the database became corrupt?
If it was because of disk space, then you will have to restore to a good version. The reason for this, is that part of the database would have been in cache memory, and since there was no disk space available, the data in memory would have been lost.

If you are using Database Journaling, then take the last good copy of the database, and apply the journal.This will bring up to the point where the crash occurred.

HansaWorld Support Team
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
kevin
Hi, we are currently testing Standard Accounts. We often get the message concurrent user limi...
15:19 24 Jun 2025
Please, also check the node, as it is not reachable, this is happening recurrently: Previsto: Run...
17:16 10 Jun 2025
You can subscribe to notifications for any post in this forum by selecting the 'star' icon on the top right corner of the topics list. You have to log in to use this functionality.