On Thursday 18 March 2004 15:41, you wrote: > Hm it really is the problem i think, so next question :) Where do I > specify the location of the temp dir? Can I do that somehow in the > /etc/my.cnf file?
Sure. Put into my.cnf: [mysqld] tmpdir=/path/to/the/tmpdir User that runs mysqld ('mysql' by default) should have enough permissions on that dir. > > Best regards > Søren > > -----Original Message----- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: 18. marts 2004 14:15 > To: [EMAIL PROTECTED] > Subject: Re: What causes this error, and how do i fix it? > > S?ren Neigaard <[EMAIL PROTECTED]> wrote: > > The following SQL (bugzilla): > > > > SELECT = > > products.product,description,disallownew,votesperuser,maxvotesperbug,v > > ote= > > stoconfirm,COUNT(bug_id) FROM products LEFT JOIN bugs ON = > > products.product=3Dbugs.product GROUP BY products.product ORDER BY = > > products.product; > > > > > > Causes this error: > > > > ERROR 1: Can't create/write to file '/root/tmp/#sql_1e8_0.MYI' > > (Errcode: = > > 13) > > > > But why and what can I do? > > Seems, --tmpdir is set to /root/tmp and MySQL server doesn't permissions > to write -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]