mike,
Friday, October 11, 2002, 12:19:40 AM, you wrote:
m> ./bin/myisamchk: error: 'data/mckesson/tempbak.frm' doesn't have a
m> correct index definition. You need to recreate it before you can do a
m> repair
Don't use myisamchk with *.frm files!
m> on a number of my tables. I have recently imported this data, from a
m> box that is totally ruined. I have no other copy of the data.
m> At first, I was getting 'Didn't find any fields in table' errors, that
m> after running mysqldump I was able to remove. But I am getting this
m> index definition error. How do I recreate the index definition?
m> I am also getting very slow response on sites with this DB.
Check you queries, are they using indexes?
Check the following chapter about optimization in the MySQL manual:
http://www.mysql.com/doc/en/MySQL_Optimisation.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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
