S?ren Neigaard <[EMAIL PROTECTED]> wrote: > The following SQL (bugzilla): > > SELECT = > products.product,description,disallownew,votesperuser,maxvotesperbug,vote= > 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]
