>Hi All,
>
>The indexes of databases go broken (so some records disappeared form table) in a networked system when a node using the software hangs or shuts down improperly. I have to Reindex all the tables of database or validate the databases to recover the index and lost data.
>
>Please help me to find any way to retain the indexes when a computer hangs.
>
>Yours
>
>Raoshan
Make sure you issue FLUSH after saving changes to each and every record. This may not guarantee success, but it will drastically reduce the number of times you have to reindex.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)