Guillermo Garron

From my head

Categories

General error: 1030 Got error 134 from storage engine

Written by Guillermo Garron .
Date: 2011-08-24 07:20:00 -0400

If you get this error General error: 1030 Got error 134 from storage engine when trying to access any PHP application that uses MySQL, do not panic as the problem is really easy to solve.

All you have to do is repair your tables, you can use PHPMyAdmin for that:

  1. Login into PHPMyAdmin
  2. Choose the database you want to work with.
  3. Check the boxes of all your tables.
  4. Below the tables, there is a drop down menu, choose “repair table” from it.

You can also use the MySQL command line,

mysql>use [database];

mysql>check table [your_table];

If you see any other thing different than this:

+-----------------+-------+----------+----------+
| Table           | Op    | Msg_type | Msg_text |
+-----------------+-------+----------+----------+
| piwik.piwik_pdf | check | status   | OK       |
+-----------------+-------+----------+----------+
1 row in set (0.00 sec)

Of course your table name will change, but the Msg_text should be OK.

If it is not OK run this command:

mysql>repair table [your_table];

That should solve your problem with General error: 1030 Got error 134 from storage engine error.


Filled under: en|linux | permalink

If you enjoyed the article, please share it

twitter | facebook | google+ | linkedin | email | reddit