/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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
