Friday, April 15, 2011

Solution 1030:Got error 139 from storage engine

Today i meet with one big problem while updating MySQL database. The error is 1030:Got error 139 from storage engine.
The problem is that rows has limit.
I was trying to change limit, but there is no need.

Solution for this is very easy. All you need to change ENGINE of your table. While engine almost does nothing, and it will not effect on your values. ( Please read http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html , before doing something ).

I had no time to read this so i executed the query:
ALTER TABLE `table_name` ENGINE = MYISAM

It worked for me. Hope it will work for you too.

6 comments:

  1. Thanks man....... very helpfull for me......

    ReplyDelete
  2. Thank you - Worked for me on MySQL 5.1 installation.

    ReplyDelete