Jo�o,
Monday, April 01, 2002, 9:12:04 PM, you wrote:
JPV> Hello everybody,
JPV> I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I
JPV> get the following error:
JPV> [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.*
JPV> myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a
JPV> correct index definition. You need to recreate it before you can do a repair
JPV> ---------
JPV> - recovering (with sort) MyISAM-table '/opt/db/mysql/netcard/d_usuario.MYI'
JPV> Data records: 767092
JPV> - Fixing index 1
JPV> - Fixing index 2
JPV> ---------
JPV> myisamchk: error: '/opt/db/mysql/netcard/d_usuario.frm' doesn't have a
JPV> correct index definition. You need to recreate it before you can do a repair
JPV> My question is: how can I repair / recreate hte index definition ? I scan the
JPV> manual, and it says nothing about it.
Don't pass *.MYD and *.frm files to myisamchk, just pass the *.MYI file or table data
directory.
Read about myisamchk syntax at:
http://www.mysql.com/doc/m/y/myisamchk_syntax.html
JPV> Thanks in advance,
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
