Hi all, I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500 MB RAM. I have a table called "sender" with 18 columns (only integers and varchars, no blobs) and with 3 indexes. The table has about 15000 records. Now I need to add one more column to the table with alter table command.
But when I do it I get: ERROR 1034: sort_buffer_size is to small Currently the size of the sort buffer is 2MB, but even when I increased it to 400MB I got same error. I tried to drop some of the indexes, which helped last time, but when I try to drop some index now, I got same 1034 error. Only workaround for this I know is to dump the table, add the column manualy in the dump file, drop the table and recreate the table from the dump. It's nasty procedure and I will have to take the server down for some time, so I hesitate to do it. I myisamchecked the table (and even optimized) and it's fine. I hope there must be something to help me. Thank you. PS: I'll send the structure of the table if it helps. Martin -- Martin Pavlas Pwrgeneration.net ICC s.r.o. --------------------------------------------------------------------- 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