Re: Table crash questions...

[Dan Tappin]

Good call... I should have figured that out my self.  The old version 
was 2.6:

/usr/bin/myisamchk (v2.6)
/usr/local/mysql-standard-4.1.8-apple-darwin7.6.0-powerpc/bin/myisamchk 
(v2.7)

This is likely why I lost my data in the first place.

Dan T


On Feb 16, 2005, at 10:57 AM, Michael Stassen wrote:

>
> Dan Tappin wrote:
>
>> I have MySQL 4.1.8 installed on OS X 10.3.8 Server and I was in the 
>> process of building a PHP / MySQL website.  After numerous connection 
>> issues with the MySQL server I decided to take a look at the status 
>> of my tables to check for corruption.
>> After running myisamchk I managed to loose all my data records for 
>> one table.  Not a big deal As I was just in a testing phase an 
>> planned to purge the data any way.  The problem is now when I run 
>> myisamchk on this table I get:
>> Warning: table file /pathtomydatafolder/users.MYI was created in 
>> MySQL 4.1+, use REPAIR TABLE ... USE_FRM to recreate it as a valid 
>> MySQL 4.0 table
>> - recovering (with keycache) MyISAM-table 'users.MYI'
>> Data records: 0
>
> You have installed mysql 4.1.8, but this error message appears to come 
> from mysql 4.0.x.  Any possibility you started the wrong server?  
> Which leads me to wonder which version of myisamchk you ran.  A PATH 
> problem, perhaps?
>
>> I tried "REPAIR TABLE users USE_FRM" with no help in resolving this 
>> message.
>> Is this anything to even worry about??
>> Dan T