Can't open file: 'products.MYI' (errno: 145)
Submitted by Kelly and Stuart on Sun, 2008-06-22 12:42.Price Tapestry
Hi David. I have contacted my hosting about this problem and... well lets just say they weren't very helpful! I wondered if you might have any theories on this?
Just lately I have been getting a problem with my databases on PHPMyAdmin.
After an update I sometimes get an error message:
"Can't open file: 'products.MYI' (errno: 145)"
When this happens I got no info from the database on my website just mysql errors.
This happens at random as I can update 5 databases on the same day with the same datafeed and only 1 might be affected.
There seems to be no link to when or why it happens.
This has only just started happening in the last couple of weeks and I haven't made any changes to the importing files on all of the site.
Any thoughts?
Hi,
A web search on error 145 indicates that the database file is corrupt; but if it is only an intermittent problem then i'm more inclined to think that it is a file handle resource issue (too many open files). I'll keep having a look into it and let you know if any tests or other possibilities come to mind...
Cheers,
David.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum