anyone any idea on this ?
>> 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.
