Re: ** Standard Engine disaster, please help !! **

Rudy Fernandes wrote: > > In article <19961204232400.SAA11546@ladder01.news.aol.com>, > mychmose@aol.com wrote: > >SE v2.03 > > > >Hi all, I have a .dat file without a .idx ( it was deleted by accident ). > > > >I now can no longer select data from the table. Is there any solution to > >this problem? > > > > > This should be worth a try. > Step 1. Create another table, say junk, within the same database. junk must > have an IDENTICAL structure to the table with the deleted idx. > You will find a dat and idx file created. > Step 2. copy/rename the junk table's idx file to the idx deleted. > e.g cp junk___123.idx deleted105.idx (N.B the idx file's prefix > will be identical to that of its dat) > Step 3. Run a 'bcheck -s' on the original table. > e.g bcheck -s deleted105 > That's it! > > ---------------------- > Rudy Fernandes > GIC, KUWAIT > ---------------------- I would make backup copies before you start, both on tape (for peace of mind) and on disc (for speed of restore), and backups of the "recovered" database. The method Rudy advises has worked for me in the past. Peter Brueton