I think I have a corrupt table and my most recent backup is too old to use. Here's the scenario: I started getting duplicate key errors for no apparent reason. The column is a medium int, the highest value was 260 (or there abouts) and it was trying to insert a 0. So I whipped out my MySQL Manual and started doing what I found in the myisamchk section. Myisamchk indicated that the index file was usable but needed to be repaired, so I repaired it. Tested the insert and still had the problem. So I read further. Tried to force the table to use a proper autoincrement value using the -a option, it told me that the table didn't have a correct index definition and I needed to recreate it before I could do a repair. So I followed the instructions and copied the MYD and MYI files somewhere else, truncated the table, copied the MYD file back and tried myisamchk with the -r -q options. Same error. If I look at the data now, it's all messed up, it even seems to be different each time I do this operation. Is there any hope at all? This is urgent! Someone please help! ____________________________________________________ UNIX is user-friendly, it's just picky about who its friends are...
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
