Errors Privelege tables and columns

[goodguy]

Hello again,

I have a question about an error in MySQL

The /var/log/mysql.log error:
051104 14:59:28 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
051104 14:59:28 /usr/sbin/mysqld: Can't open file: 'columns_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'columns_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'columns_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'columns_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'tables_priv.MYI'. (errno: 138)
051104 14:59:36 /usr/sbin/mysqld: Can't open file: 'columns_priv.MYI'. (errno: 138)

I tryed to repaire this error with /usr/local/directadmin/scripts/ mysql_fix_privilege_tables but it doesn’t work. I get still the error:

ERROR 1016 at line 4: Can't open file: 'tables_priv.MYI'. (errno: 138)
ERROR 1016 at line 5: Can't open file: 'tables_priv.MYI'. (errno: 138)
ERROR 1016 at line 6: Can't open file: 'columns_priv.MYI'. (errno: 138)
ERROR 1016 at line 12: Can't open file: 'tables_priv.MYI'. (errno: 138)
ERROR 1016 at line 13: Can't open file: 'columns_priv.MYI'. (errno: 138)

So i tryed to find the filename: find / -name tables_priv.MYI –print and the filename is in /var/lib/mysql/mysql/. that’s good because the other filenames are there too. I checked the permissions and thats 660.

I had change the permissions to 777 on the hole directory but that will not solved the problem. Can anybody help me with this problem?

 

[boydverbeek]

looks like this post was made in 2005 but i would like to know if anyone solved this problem, cuase i seem to have the same thing in some way.


#1016 - Can't open file: 'jos_vm_product.MYI'. (errno: 138)


i only have this but it's the most important one im not willing to loose, so if anyone can help me out on this i would apriciate this.

 

[boydverbeek]

bump

 

[resolveit]

Hi boydverbeek,

The errno 138 is the following error....

MySQL error code 138: Unsupported extension used for table

It seems that your database file was renamed somehow, the extention MYI is actually used for MySql Index and not for the tables.

regards,