Mysql:"error: 1016: Can't open file:"

by Mohan 2012-09-20 08:15:46

<font color=#0000B3>
<h2>
"error: 1016: Can't open file:"</h2> If it's from an orphaned file, not in the database
but on disk, then, the disk file may need to be deleted.

myisamchk can help with damaged files. It's best to stop the database.

# su -
# mysqladmin shutdown

# cd /usr/local/var/database
# myisamchk *

# /etc/init.d/mysql restart
</font>

Tagged in:

556
like
0
dislike
0
mail
flag

You must LOGIN to add comments