By nickblue on
this am I started getting emails from Cron with a bunch of code and now I get thie error message when trying to visit the drupal site, http://www.nbsweb.net:
Fatal error: Can't open file: 'cache.MYD'. (errno: 145) query: SELECT data, created, headers FROM cache WHERE cid = '/' in /home/webadmin/support.nbsweb.net/html/includes/database.mysql.inc on line 97
I stopped and started mysql and got it going but not the site.
No changes had been made and it was running create for at least a couple of months without incident. Any suggestions are appreciated.
Comments
Cache size
It's possible the cache has grown too large. Try repairing the cache table and wiping it clean from phpmyadmin.
am trying to determine how to repair or wipe the cache
I 'dropped' the cache table - not a good idea I suppose. Any suggestions on how to repair or wipe from within phpmyadmin?
---------
Visit the Nick Blue online community:
http://www.nickblue.com/community/
You can recreate the table ea
You can recreate the table easily by loading the rlevant part of the database.mysql file through phpmyadmin.
DELETE FROM cache;
would have been the proper sql command to wipe the database.
--
If you have troubles with a particular contrib project, please consider to file a support request. Thanks.
--
Drupal services
My Drupal services
an alternative
if its a mysql server, you can use TRUNCATE cache; Its faster than using delete from cache; as it drops the entire table, and re-creates it along with the indexes. Note: THis is not ANSI SQL
loading relevant part of database.mysql
Thanks for the great help - would you know where in phpmyadmin I can just reload the cache table? I did manage to export just the cache table from another drupal site; how can I import it?
---------
Visit the Nick Blue online community:
http://www.nickblue.com/community/
Sorry, no, I haven't used it
Sorry, no, I haven't used it for a while. Reading the docs will probably help. Be sure to import only the table's structur not any content from another site. Might lead to unexpected results...
--
If you have troubles with a particular contrib project, please consider to file a support request. Thanks.
--
Drupal services
My Drupal services
a neat tool
If you have a linux console, you can use the command `perror` to actually find more description about the errno: returned to you.
For example, perror 145 returns:
MySQL error: 145 = Table was marked as crashed and should be repaired
cool tip
Thank you for the tip - I'll be sure to do it.
Best,
Nick
---------
Visit the Nick Blue online community:
http://www.nickblue.com/community/
thanks for the great support
I was really sweating when my drupal site crashed - thanks for the very insightful support; I went ahead and just manually created the cache table based on another drupal site's cache table and bam it worked! woohoo:). Thanks.
---------
Visit the Nick Blue online community:
http://www.nickblue.com/community/