Mysql Tricks : error 1016

  "error: 1016: Can't open file:" 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

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image