Re: sporadic error 13 on windows

2007-11-02 Thread Artem Kuchin
Kristen G. Thorson wrote: -Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 9:23 AM To: Baron Schwartz Cc: mysql@lists.mysql.com Subject: Re: sporadic error 13 on windows DBD::mysql::st execute failed: Can't create/write to file '

RE: sporadic error 13 on windows

2007-11-02 Thread Kristen G. Thorson
-Original Message- From: Artem Kuchin [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 9:23 AM To: Baron Schwartz Cc: mysql@lists.mysql.com Subject: Re: sporadic error 13 on windows DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.MYD' (

Re: sporadic error 13 on windows

2007-11-02 Thread Artem Kuchin
Baron Schwartz wrote: What do you get from the following: mysql> show variables like '%tmp%'; 1) if i set tmpdir=C:/temp it shows: mysql> show variables like '%tmp%'; +---+---+ | Variable_name | Value | +---+---+ | max_tmp_tables| 32

Re: sporadic error 13 on windows

2007-11-02 Thread Baron Schwartz
What do you get from the following: mysql> show variables like '%tmp%'; Artem Kuchin wrote: anyone any idea on this ? On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote: I am running Server version: 5.0.45-community-nt MySQL Community Edition (GPL) on WIndows 2003 R2 Service Pack 2 Standar

Re: sporadic error 13 on windows

2007-11-02 Thread Artem Kuchin
anyone any idea on this ? On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote: I am running Server version: 5.0.45-community-nt MySQL Community Edition (GPL) on WIndows 2003 R2 Service Pack 2 Standard Edition I have a database dig perl script with basically does a lot of SELECT [somefield] as

Re: sporadic error 13 on windows

2007-10-31 Thread Artem Kuchin
Just a thought, (I'm certainly no wondows guy) but perhaps your setting for the TMP directory would be respected if you used the DOS format path with the backslash.. tmpdir=C:\temp vs. tmpdir=C:/temp tried it, still: DBD::mysql::st execute failed: Can't create/write to file '#sql_152c_0.MYD'

sporadic error 13 on windows

2007-10-31 Thread Artem Kuchin
I am running Server version: 5.0.45-community-nt MySQL Community Edition (GPL) on WIndows 2003 R2 Service Pack 2 Standard Edition I have a database dig perl script with basically does a lot of SELECT [somefield] as tt FROM table; When i run it i get: DBD::mysql::st execute failed: Can't crea