Jump to content
ameliabob

Error #1114 - The table 'closed' is full

Recommended Posts

I received the error  code " #1114 - The table 'closed' is full " from phpmysql after adding a structure and then I think I closed the table.  When I go back and try to extend the table by adding more columns I get this error.  I have tried adding the columns by either using the phpmysql structure and by using the SQL command 'ALTER TABLE closed ADD daysHeld int' they both give me the table full.  I have only added one row into the table.

Is the only answer to delete and start over??

Share this post


Link to post
Share on other sites

Either you have limited Disk Space on your operating system, or the limit for database size has maxed out! set in its mysql config file.

Share this post


Link to post
Share on other sites

Usually wherever you installed MySQL, or if you're using a package manager it might have all the config files in one place.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...