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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×