Table '# sql-5f8_9c' is full

Question

im trying to remove a foreign key with the following syntax (5.0.45-community-nt):

alter table [table] drop foreign key [fk_name] 

but I get the following error:

 The table '#sql-5f8_9c' is full – 99543 ms 

any ideas?

thanks!

Answer 1

ALTER TABLE often required to create a copy of the entire table, so you need enough space on your file system to simultaneously store two copies of the data, as it restructures this table.

It may seem strange that he needs to make a copy of the table, since you are simply dropping the constraint. In later versions of MySQL, some ALTER TABLE operations have been optimized, so they do not require table restructuring. But you have been using the MySQL version since July 2007!

See also:

• The table is full

• InnoDB Error "Full Table"