I recently rebooted our server (Solaris) and now I get "ERROR 1017: Can't find file: './path/to/table_name.frm'" from MySQL. I suppose maybe I should have shut down MySQL before rebooting the server. However, I didn't know this before. I can see all the .frm, .MYD, and .MYI files, but MySQL can't see them. And while in MySQL, I can do "show tables" and it workds, but a show columns or select command gives the error. Is there any way to get it to recognize those files?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error 1017: Cannot file .frm files
- Thread starter mturnbo
- Start date
hi
if you have rebooted the server using some standard shutdown command (i'm not a solarix user so i don't know it) i suppose there are scripts present that shutdown all your daemons
your error looks more like an hdd prob - corrupt file or so
if you have backup of you database files, try to use them
is this occuring on all tables or only on one?
if you have rebooted the server using some standard shutdown command (i'm not a solarix user so i don't know it) i suppose there are scripts present that shutdown all your daemons
your error looks more like an hdd prob - corrupt file or so
if you have backup of you database files, try to use them
is this occuring on all tables or only on one?
- Status
