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 <[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 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/[EMAIL PROTECTED]
--
- michael dykman
- [EMAIL PROTECTED]
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
