List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:November 2 2007 12:17pm
Subject:Re: sporadic error 13 on windows
View as plain text  
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 <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.
> 
> 
> 
> 

-- 
Baron Schwartz
Xaprb LLC
http://www.xaprb.com/
Thread
sporadic error 13 on windowsArtem Kuchin31 Oct
  • Re: sporadic error 13 on windowsArtem Kuchin1 Nov
  • Re: sporadic error 13 on windowsArtem Kuchin2 Nov
    • Re: sporadic error 13 on windowsBaron Schwartz2 Nov
  • Re: sporadic error 13 on windowsArtem Kuchin2 Nov
    • RE: sporadic error 13 on windowsKristen G. Thorson2 Nov
  • Re: sporadic error 13 on windowsArtem Kuchin2 Nov