Introducing PTWin

Introducing
PTWin32

Support Services
Support
Services

Downloads
Downloads

User Tips
User Tips

Contact Us
Contact Us

Introducing PTWin
Home

  PTWin User Tips / System Administration 

Pushing the Post Button

A blueprint for recovery
The \Struct directory
Rebuilding corrupted database tables from duplicate structures

Tip #: 4.2.85
Ver(s):PTWin32, V2

Like everything else in the universe, computers are not catastrophe proof. No matter how scrupulously you attend to your hardware and software eventually the odds will catch up with you and something will happen to mess up your data.

Usually it’s something like a power failure but lots of things can contribute to the corruption of data. When this happens to your PTWin32 data there are tools we provide to help in your attempts to repair your data.

There are generally 2 ways a database table can be corrupted. The first involves corruption in the data that can cause the delimiters between the field values to move. To fix this we simply consult the header information of the database table, which stores the delimiter locations, and rebuild the corrupted data.

But what if the header information that details the underlying structure of the table has been damaged? Well we’ve thought of that and built into our Tutility Table Repair program the ability to Borrow the structure of an undamaged table and apply it to your corrupted table.

You will find that your /PTWin32 directory contains a subdirectory called /Struct that contains a fresh, empty set of PTWin32 database tables. These tables match the tables in your \PTWin32\Data directory.

If your PTWin32 database tables have had their structures damaged you can rebuild that structure by Borrowing the structure of the damaged table’s mate in the PTWin32\Struct directory. Just push the Borrow Structure button on the Restructure Table window of PTWin32’s Tutility Table Repair program and point to the file of the same name in the \Struct directory to attempt your data repair.

 

Return to System Administration menu