Hello everybody, I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I get the following error:
>------------------------< [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.* myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair --------- - recovering (with sort) MyISAM-table '/opt/db/mysql/netcard/d_usuario.MYI' Data records: 767092 - Fixing index 1 - Fixing index 2 --------- myisamchk: error: '/opt/db/mysql/netcard/d_usuario.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair >-----------------------< My question is: how can I repair / recreate hte index definition ? I scan the manual, and it says nothing about it. Thanks in advance, -- Joćo Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852-9008 Ramal 31 [EMAIL PROTECTED] --------------------------------------------------------------------- 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