List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:May 1 2002 8:58pm
Subject:Re: Error repairing: how do you Recreate an Index?
View as plain text  
Error 13 is a permission problem.
Mysql does not own the file.
You probably repaired it while logged on as root,
and changed ownership of the file.

Make sure it is owned by mysql.

MySQL wrote:

>Hi all,
>
>I was trying to repair a table with myisamchk and got the following message:
>
>"error: 'x.MYD' doesn't have a correct index definition. You need to recreate it
> before
>you can do a repair"
>
>(If I try to access the table  from mysql, it tells me that the file x.MYD doesn't
> exist.
> It does exist! It's there! And it was working fine until I tried doing an extended
>repair on it using )
>
>Attempted: mysqlcheck -r  on the database but when it gets to the x.MYD file, it tells
> me:
>error: File '/.../x.MYD' not found (Errcode: 13)
>
>I swear the file is there, where it's looking for it.
>
>Any suggestions?
>
>Paul Fabris
>
>
>---------------------------------------------------------------------
>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 <mysql-thread107744@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Error repairing: how do you Recreate an Index?MySQL1 May
  • Re: Error repairing: how do you Recreate an Index?Joseph Bueno1 May
  • Re: Error repairing: how do you Recreate an Index?Gerald Clark1 May