PDA

View Full Version : Mysql error


S2S-Robert
10-11-2003, 10:30 AM
Can't open file: 'members.MYI'. (errno: 145)
Any clues on this one? What might have caused it (perhaps an invalid mysql command?) but more important how do I fix it! :D

ProWebUK
10-11-2003, 11:03 AM
where are you recieveing that error? also, check that members.MYI exists in /var/lib/mysql

DirectAdmin Support
10-12-2003, 11:41 AM
Hello,

I think I've seen this error before, and in that case, it was a permission error.cd /var/lib/mysql
chown -R mysql:mysql username_databasename
chmod 700 username_databasename
chmod 660 username_databasename/*

Hope this helps.

John