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]
