Martin, Tuesday, July 23, 2002, 10:29:13 AM, you wrote: MP> I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500 MP> MB RAM. I have a table called "sender" with 18 columns (only integers MP> and varchars, no blobs) and with 3 indexes. The table has about 15000 MP> records. Now I need to add one more column to the table with alter table MP> command.
MP> But when I do it I get: MP> ERROR 1034: sort_buffer_size is to small MP> Currently the size of the sort buffer is 2MB, but even when I increased MP> it to 400MB I got same error. I tried to drop some of the indexes, which MP> helped last time, but when I try to drop some index now, I got same 1034 MP> error. MP> Only workaround for this I know is to dump the table, add the column MP> manualy in the dump file, drop the table and recreate the table from the MP> dump. It's nasty procedure and I will have to take the server down for MP> some time, so I hesitate to do it. MP> I myisamchecked the table (and even optimized) and it's fine. MP> I hope there must be something to help me. Hm.. Error 1034 means: "Incorrect key file for table ..." not a "sort_buffer_size is to small" How did you installed the server? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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