The comment you are replying to does not exist.

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

erakomp

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.

  1. Login to phpMyAdmin. You can using your cPanel.
  2. Choose the affected database. I only have one database, so I don't need to do anything.
  3. 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.
  4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose "Repair Table"
Table Op Msg_type Msg_text
erakomp_drpl1.cache_menu repair info Found block that points outside data file at 11733...
erakomp_drpl1.cache_menu repair status OK


Refreshing my site and now the problem fix :)



Reply

The content of this field is kept private and will not be shown publicly.
If you have a Gravatar account, used to display your avatar.
  • Lines and paragraphs break automatically.

More information about formatting options

This blog uses the CommentLuv Drupal plugin which will try and parse your sites feed and display a link to your last post, please be patient while it tries to find it for you.
CAPTCHA
Jawab pertanyaan ini untuk membedakan apakah anda pengunjung atau spam.
3 + 7 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.