Can't create/write to file '/root/tmp/#sql_1570_0.MYI'

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Can't create/write to file '/root/tmp/#sql_1570_0.MYI'

Postby baretto » 13. August 2006 09:08

Hi,
I have installed XAMPP on /opt
It works, but often, some queries in web page and some operations via PhpMyAdmin do not work.
I get this error:
Code: Select all
#1 - Can't create/write to file '/root/tmp/#sql_1570_0.MYI' (Errcode: 13)


What's this? How can I do?
baretto
 
Posts: 5
Joined: 09. July 2006 15:11

Postby baretto » 21. August 2006 19:52

up: someone can help me?
baretto
 
Posts: 5
Joined: 09. July 2006 15:11

Postby Dave_L » 21. August 2006 20:20

That looks like a permission error:

$ /opt/lampp/bin/perror 13
System error: 13 = Permission denied


But I don't understand why MySQL is trying to use the directory /root/tmp.
User avatar
Dave_L
 
Posts: 212
Joined: 23. October 2004 00:43

Postby baretto » 22. August 2006 19:16

thanks
I have typed (as user):
/opt/lampp/bin/perror 13
and I get:
OS error code 13: Permission denied

But this error is alive: I can't work fine nor via phpMyAdmin nor in web pages...

how can I do?
there is some parameters to modify in order to resolve this problem?
baretto
 
Posts: 5
Joined: 09. July 2006 15:11

Postby Dave_L » 22. August 2006 19:33

Apparently MySQL is using the wrong tmp directory. I Googled for that error message, and saw some suggested solutions. The easiest one is to check /opt/lampp/etc/my.cnf, and verify that the following is present:

Code: Select all
[mysqld]
...
tmpdir = /tmp/


If you change that file (back it up first), you'll need to restart MySQL.
User avatar
Dave_L
 
Posts: 212
Joined: 23. October 2004 00:43


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 4 guests