From: Artem Kuchin
Date: November 1 2007 7:47am
Subject: Re: sporadic error 13 on windows
List-Archive: http://lists.mysql.com/mysql/209833
Message-Id: <00a701c81c5b$70391550$0c00a8c0@Artem>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

> 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' (Errcode: 13) at cleanfilestore.pl line 89, <STDIN> line 
1.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at cleanfilestore.pl line 90, <STDIN> line 1.

--
Artem



> On 10/31/07, Artem Kuchin <matrix@stripped> 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 tt FROM table;
>>
>>
>> When i run it i get:
>>
>> DBD::mysql::st execute failed: Can't create/write to file 'C:\Program Files\MySQL\MySQL Server 5.0\Data\#sql_bdc_0.MYI' (Errcode
>> : 13) at cleanfilestore.pl line 89, <STDIN> line 1.
>> DBD::mysql::st fetchrow_array failed: fetch() without execute() at cleanfilestore.pl line 90, <STDIN> line 1.
>> DBD::mysql::st execute failed: Can't create/write to file 'C:\Program Files\MySQL\MySQL Server 5.0\Data\#sql_bdc_0.MYI' (Errcode
>> : 13) at cleanfilestore.pl line 89, <STDIN> line 1.
>> DBD::mysql::st fetchrow_array failed: fetch() without execute() at cleanfilestore.pl line 90, <STDIN> line 1.
>> DBD::mysql::st execute failed: Can't create/write to file '#sql_bdc_0.MYD' (Errcode: 13) at cleanfilestore.pl line 89, <STDIN> l
>> ine 1.
>> DBD::mysql::st fetchrow_array failed: fetch() without execute() at cleanfilestore.pl line 90, <STDIN> line 1.
>>
>>
>> I have
>> [mysqld]
>> tmpdir=C:/temp
>>
>> in my.ini
>>
>> SO, first of all, why is it trying to create something in Programe files?
>> Why there are files w/o path at all (Can't create/write to file '#sql_bdc_0.MYD') ?
>>
>> These error accure at different moments every time script is run.
>>
>> Anynow any idea what's going on here?
>>
>> TEMP has full rights for ALL. But anyway, as you see, it is not even mentioned here.
>>
>> --
>> Regards,
>> Artem
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdykman@stripped
>>
>>
>
>
> -- 
> - michael dykman
> - mdykman@stripped
>
> - All models are wrong.  Some models are useful.