List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:February 10 2000 10:37pm
Subject:Re: mysqlhotcopy available (finally)
View as plain text  
>>>>> "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.
Thread
mysqlhotcopy available (finally)Tim Bunce8 Feb
  • mysqlhotcopy available (finally)Michael Widenius9 Feb
    • Re: mysqlhotcopy available (finally)Tim Bunce9 Feb
      • Re: mysqlhotcopy available (finally)Michael Widenius10 Feb
        • Re: mysqlhotcopy available (finally)Tim Bunce10 Feb
          • Re: mysqlhotcopy available (finally)Michael Widenius11 Feb
Re: mysqlhotcopy available (finally)web9 Feb