mysql error 1030 got error -1 from storage engine

I received the following message while working while working with a pre-existing existing database and adding some new tables. I was specifying the table creating using this Mysql Manager.

The Manager itself was not at fault for the error and it appeared to be related to a table data corruption or disk space issue, but that turned out not to be the case as there was gigs of space left in the partition and a CHECK TABLE succeded without issue. A backup and restore did not solve the problem either. An inspection of the filesystem revealed that the database directories and permissions were correct, however, there appeared to be a few files missing per table with the tables that were not working. A careful re-examination of the table create statements revealed a difference in dbengine selection between the existing database tables and new database tables. A simple removeall of the storage engine specifier fixed the problem when the tables were re-created.

ttessier

About ttessier

Professional Developer and Operator of SwhistleSoft
This entry was posted in Tech and How To. Bookmark the permalink.

One Response to mysql error 1030 got error -1 from storage engine

  1. This blog was… how do I say it? Relevant!! Finally I have found
    something which helped me. Thanks a lot!

Leave a Reply to google plus apple Cancel reply

Your email address will not be published. Required fields are marked *