General error: 1030 Got error 134 from storage engine

Written by
Date: 2011-08-24 07:20:00 00:00


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.