In my phpmyadmin , when am adding a new column to my table , mysql throwing me error table xxx is full i also search on google , but did not get help.

am also gone through dba.stackexchange.com answer realeted to this question , but no help. https://dba.stackexchange.com/questions/43503/error-1114-hy000-the-table-is-full-with-innodb-file-per-table-set-to-aut

migrated from stackoverflow.com Apr 17 at 10:30

This question came from our site for professional and enthusiast programmers.

  • dev.mysql.com/doc/refman/8.0/en/full-table.html – Sachin Shah Apr 17 at 6:41
  • are you using InnoDB ? – Rakesh Jakhar Apr 17 at 6:56
  • You have a database admin problem, not a programming one, so you should ask this question on the dba site, not here. – Shadow Apr 17 at 7:10

This is because your temp folder is full. you can make a new temp folder where is more space after that let mysql know about your newly created temp folder(dont forget to restart mysql service), or you can also clear your temp folder, it will work. you can follow this stackoverflow link for more information ERROR 1114 (HY000): The table 'XXX' is full

  • Thanks for details clear your temp folder i hit this ubuntu command sudo find /tmp -type f -atime +10 -delete and solved my error – Developer Apr 17 at 6:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy