Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Subject: Re: sporadic error 13 on windows

Subject: Re: sporadic error 13 on windows

2007-11-02       - By Baron Schwartz

 Back
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@(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 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/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@(protected)