>>>>> "Tim" == Tim Bunce <Tim.Bunce@stripped> writes:
Tim> On Wed, Feb 09, 2000 at 06:47:29PM +0200, Michael Widenius wrote:
<cut>
>> To create the .MYI file from the index file one must currently do as follows:
Tim> ^^^^^- .frm ?
Sorry; Yes, .frm is correct.
>> - Copy only the .frm file into a database.
>> - do 'mysql -e "delete from database.table_name"'
>>
>> After the above one can copy the new 'empty' .MYI file to where the
>> .MYD file is and use 'myisamchk -r table_name' to re-generate the index
>> for the data.
Tim> So the "copy the first 65K of the index file" is only worth doing for .MYI's?
Yes. (actually 4K or 8K should be ok, but lets say 65K to make it
safe for the future)
Regards,
Monty
PS: I am just now building 3.22.32 and mysqlhotcopy is included in the
distribution.
