You probably moved the databases while logged in as root.
mysql needs to own the files.
chown -R mysql /var/lib/mysql
( or whatever your data path is )
Dan Uyemura wrote:
> "Error on rename of .\DATABASENAME\TABLENAME.MYI to
> Has anyone seen this errcode pop up on them when trying to alter a table? I
> have recently moved databases from one server to another, and ever since
> doing so, I have been seeing this error pop up intermittantly. I think it
> is what is causing my tables to become corrupted, and thus my web site
> (which is heavily reliant on the DB) to continually go down. The error I
> end up getting on the site is usually the following:
> [TCX][MyODBC]Can't open file: 'members.MYD'. (errno: 145)
> Although sometimes I get the errno: 127 (corrupt table) message.
> One thing I have noticed is whenever I try to do an alter and it results in
> the errcode 13, my table ends up with the message "XX clients is using or
> hasn't closed the table properly" and it tells me that the table is usable,
> but should be repaired when I do a myisamchk on the table. Once it has
> gotten to this state, sooner or later, it will die on the site, but not
> What is odd is I get this error when I try to alter a table, however, I
> think somehow the users on the site are triggering it to happen, and the
> site only does transactions, there is no altering of the tables involved
> from the site.
> If anyone could assist, it would be GREATLY appreciated. This has been
> causing myself and my boss much agony and sleepless nights, as it seems to
> conveniently die at 4AM :)
> Dan Uyemura
> GSociety, Inc.
> 7060 Hollywood Blvd. #800
> Hollywood, CA 90028
> (v) (323) 337-0141
> GSociety family of companies:
> 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-thread87586@stripped>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Gerald L. Clark
|• errcode 13:||Dan Uyemura||10 Oct|
| • Re: errcode 13:||Gerald Clark||10 Oct|