First make a backup of your MYD file if you haven't already done so. Then delete the useless index file (MYI) and run myisamchk with the --quick flag which will hopefully recreate the index file. Also consult the chapter on crash recovery with myisamchk at http://www.mysql.com/doc/T/a/Table_maintenance.html as it has saved my own data numerous times.
Good luck, Ron Jamison -----Original Message----- From: Andy Woolley [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 2:44 AM To: [EMAIL PROTECTED] Subject: datafile.MYI has been destroyed & can't recover Hi, I've got a 300 MB database file with a useless MYI file and I cant seem to reconstruct it. Anyone know how I can get the data back. if I use myisamchk -o it destroys all the data in the file so I'm kinda stumped. Cheers Andy PS I need to enter SQL and Query cos this mail bouced at first. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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