Drupal : Repairing MySQL Table
This morning, I got this message in one of my sites 'erakomputer':
Table './erakomp_drpl1/cache_menu' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_menu
I don't know what's wrong with my site, there's nothing wrong when I open it last night but suddenly this morning that message has flooding my site pages. Thanks God Drupal Forum give a solution for this. They said it was problem with one of tables in MySQL database. They guess if the hosting machine crashes (i.e. does not get shutdown cleanly), this can happen. They suggesting I need to run the REPAIR command from mysql or phpMyAdmin.
How to repair it :
The table need to repair is cache_menu table.
- Login to phpMyAdmin. You can using your cPanel.
- Choose the affected database. I only have one database, so I don't need to do anything.
- In the main panel, I could see a list of my database tables. Then check the boxes by the tables that need repair. For me cache_menu tables.
- At the bottom of the window just below the list of tables, there is a drop down menu. Choose "Repair Table"
|erakomp_drpl1.cache_menu||repair||info||Found block that points outside data file at 11733...|
Refreshing my site and now the problem fix :)
- roemasa's blog
- Add new comment
- 1525 reads