List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:September 1 1999 6:18am
Subject:i goofed - restoring a ISD file?
View as plain text  
Jerry Preeper writes:
 > I just made a big goofup with a perl script that imports raw data from text
 > files into tables in my database.  I turned off my backup program so I
 > don't overwrite the old files on the backup hard drive.  I just compared
 > the files from the database on the two hard drives and the only file that
 > is different is the .ISD file for this table.  Is it safe to just copy the
 > old .ISD file over the new one to restore everything from before my goofup
 > or must I do something different?
 > Jerry

Hello Jerry,

If the dates match too with .frm and .ISM files, then you can do as
you suggested. Do mysqladmin flush-tables afterwards.  If something
goes wrong despite everything, run isamchk on the table. More about
isamchk you can find from the manual, or isamchk --help.

Regards,

- Jani

-- 
+---------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___				|
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|		Jani Tolonen	|
|    /*/ /*/ /*/   \*\_   |*|   |*||*|		jani@stripped	|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|		Helsinki	|
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____	Finland		|
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^			|
|             /*/             \*\		Developers Team	|
+---------------------------------------------------------------+
Thread
i goofed - restoring a ISD file?Jerry Preeper1 Sep
  • i goofed - restoring a ISD file?Jani Tolonen1 Sep