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