1114 (HY000): The table is full

by

EDIT: First check, if you did not run out of disk-space, before resolving to the configuration-related resolution.

You seem to have a too low maximum size for your innodb_data_file_path in your my.cnf, In this example

innodb_data_file_path = ibdata1:10M:autoextend:max:512M

you cannot host more than 512MB of data in all innodb tables combined.

Maybe you should switch to an innodb-per-table scheme using innodb_file_per_table.

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. How do I quickly rename a MySQL database (change schema name)?
  3. How to debug Lock wait timeout exceeded on MySQL?
  4. Is there a REAL performance difference between INT and VARCHAR primary keys?
  5. MySQL AUTO_INCREMENT does not ROLLBACK
  6. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  7. How to shrink/purge ibdata1 file in MySQL
  8. Restore table structure from frm and ibd files
  9. MySQL InnoDB not releasing disk space after deleting data rows from table
  10. What’s the difference between MyISAM and InnoDB? [duplicate]
  11. Why is MySQL InnoDB insert so slow?
  12. MySql: MyISAM vs. Inno DB! [closed]
  13. Prevent auto increment on MySQL duplicate insert
  14. UUID performance in MySQL?
  15. Force InnoDB to recheck foreign keys on a table/tables?
  16. What is MySQL’s default ON DELETE behavior?
  17. Is there any performance gain in indexing a boolean field?
  18. Why does MySQL autoincrement increase on failed inserts?
  19. How can I check MySQL engine type for a specific table?
  20. MySQL InnoDB: autoincrement non-primary key
  21. How do I rename a MySQL database (change schema name)?
  22. How to regex in a MySQL query
  23. MySQL Integer vs DateTime index
  24. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  25. How do I lock on an InnoDB row that doesn’t exist yet?
  26. Defining Composite Key with Auto Increment in MySQL
  27. MySQL DROP all tables, ignoring foreign keys
  28. “Unknown column in ‘field list'”, but column does exist
  29. Should I always prefer MySQL InnoDB over MyISAM?
  30. How can I rebuild indexes and update stats in MySQL innoDB?

Leave a Comment