CODEWITHSUNDEEP
mysql
Amr Ezz
Amr Ezz

Reputation: 89

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 Error Msg

#1030 - Got error -1 from storage engine

Upvotes: 1

Views: 10656

Answers (3)

Paul Kenjora
Paul Kenjora

Reputation: 2004

You will get this error if /etc/my.cnf you have innodb_force_recovery turned on. Comment out that option, restart the server and try the data import again.

Upvotes: 1

Avinash Babu
Avinash Babu

Reputation: 6252

This error is mainly due to the low memory which means that you don't have enough memory for allocating to your table or database.

Please have a look here.It would be helpful.

Upvotes: 2

danmullen
danmullen

Reputation: 2510

This usually means you've ran out of disk space. Check using df -h and delete any large log files or other files taking up a lot of space.

Failing that, check your memory usage.

Upvotes: 2

Related Questions