When trying to repair tables (or optimise), there seems to be an error that is giving me a hard time.
The SQL statement REPAIR TABLE mytablename; returns the following
+---------------------+--------+----------+----------------------------------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +---------------------+--------+----------+----------------------------------------------------------------------------------------------+ | mydbase.mytablename | repair | error | 1 when fixing table | | mydbase.mytablename | repair | Error | Can't change ownership of the file '/hds/wd1tb_2/mysql/mydbase/mytablename.MYD' (Errcode: 1) | | mydbase.mytablename | repair | status | Operation failed | +---------------------+--------+----------+----------------------------------------------------------------------------------------------+
So, the only solution up to now is to
chmod -R 700 /hds/wd1tb_2/mysql/ chown -R mysql:mysql /hds/wd1tb_2/mysql/
This error has already been reported as a big long time ago, but it seems to be still there, this is the only way around the situation, and it does not seem to have been resolved with MySQL 5.5.33-0+wheezy1