Jump to content


Photo

mysql errors, need help fast.


  • Please log in to reply
2 replies to this topic

#1 xfactor19

xfactor19
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 23 December 2003 - 05:43 PM

myisamchk -r phpbb_posts.MYD

myisamchk: error: \'phpbb_posts.MYD\' doesn\'t have a correct index definition. You need to recreate it before you can do a repair


Its too damaged for repair I guess and now I have to recreate it but I don\'t know how? I have searched around.

#2 DylanBlitz

DylanBlitz
  • Members
  • PipPipPip
  • Advanced Member
  • 99 posts
  • LocationOC Baby!

Posted 24 December 2003 - 12:20 AM

did you try doing the safe repair that mysql suggests?

http://www.mysql.com.../en/Repair.html

#3 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 24 December 2003 - 02:14 AM

drop the index and then do a create index.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users