Deleting the MYSQL tables :|

[Grzeslaw]

Hello

From time to time, I have the very peculiar problem.
Some users report me, that their sql tables has been broken
The communique is: (for example)

#1017 - Can't find file: 'LAM_security_role.MYI' (errno: 2)

What could it be?
What is the reason ?
Anyone del it.

 

[AndyReed]

#1017 - Can't find file: 'LAM_security_role.MYI' (errno: 2)

Make sure MySQL directory has the correct ownership and permission:
chmod -R 0660 /var/lib/mysql/mysql
chown -R mysql:mysql /var/lib/mysql

Then, re-compile MySQL
/scripts/mysqlup --force

 

[Grzeslaw]

The folder /var/lib/mysql is olready owner by mysql.mysql recursively. Also the permissions for this folder are good [;

What can it be ?:>