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
