* Silmara > When I try to use the following command > > ALTER TABLE TABLE_1 DROP PRIMARY KEY; > > I get one error > > ERROR1114: The table '#sql-240_2' is full > > My table have 309195 records. > > How can I resolve this problem?
You probably have a full disk. When you ALTER a table, mysql will often recreate the entire table by copying the existing one, thus you need to have more free disk space than the size of the table you want to ALTER. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
