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


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.


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 <a href="http://wiki.jumpbox.com/doc/runtime/faq/mysql_maintenance" rel="nofollow">here</a>.It would be helpful.


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


  • How is user.dir configured for Tomcat servlets?
  • Serializing socket
  • Collect HostCPU utilisation and disk I/O speed using XenServer Java API
  • Are there algorithms for putting a digest into the file being digested?
  • Errno 2 using python shutil.py No such file or directory for file destination
  • How to get or calculate size of Azure File/Share or Service
  • How to import Navit into Eclipse and use it in own android project
  • Where to save the local DB created for iphone app?
  • Binary Tree Traversal Sum Of Each Depth
  • get passwords from chrome
  • Small video playback
  • iOS 6 dateFromString returns wrong date
  • Selecting a subset of data in ServiceStack.OrmLite
  • Does the Azure table storage API cache results?
  • Installing PHP 7 on digitalocean
  • Redshift Querying: error xx000 disk full redshift
  • Django model inheritance, filtering models
  • Breaking out column by groups in Pandas
  • Error when parsing timestamp with pandas read_csv
  • How to clear text inside text field when radio button is select
  • How to avoid particles glitching together in an elastic particle collision simulator?
  • Recording logins for password protected directories
  • R - Combining Columns to String Based on Logical Match
  • Adding a button at the bottom of a table view
  • Splitting given String into two variables - php
  • Getting last autonumber in access
  • What is Eclipse's Declaration View used for?
  • Check if a string to interpolate provides expected placeholders
  • Does CUDA 5 support STL or THRUST inside the device code?
  • When should I choose bucket sort over other sorting algorithms?
  • How do you troubleshoot character encoding problems?
  • Delete MySQLi record without showing the id in the URL
  • GridView Sorting works once only
  • 0x202A in filename: Why?
  • Is there a mandatory requirement to switch app.yaml?
  • Use group_by to filter specific cases while keeping NAs
  • What are the advantages and disadvantages of reading an entire file into a single String as opposed
  • Understanding cpu registers
  • How does Linux kernel interrupt the application?
  • reshape alternating columns in less time and using less memory