Problems with the Linux version of XAMPP, questions, comments, and anything related.
by cs02sc » 23. March 2006 17:29
I have XAMPP set up on a mandriva 2006 installation.
I have installed it fine but i have a problem that when i go into phpmyadmin and look at a table is gives the following error:
Error
SQL query: Edit
SHOW FULL FIELDS FROM `customers` ;
MySQL said: Documentation
#1 - Can't create/write to file '/root/tmp/#sql_2c9c_1.MYI' (Errcode: 13)
Anyone got any ideas, becuase we really are in tears over this
-
cs02sc
-
- Posts: 4
- Joined: 23. March 2006 17:20
by Oswald » 24. March 2006 13:10
Dear cs02sc!
Did you made any changes to /opt/lampp/etc/my.cnf?
Greetings
Oswald
-
Oswald
- Apache Friends
-
- Posts: 2718
- Joined: 26. December 2002 19:51
- Location: Berlin, Germany
- Operating System: Linux
-
by cs02sc » 24. March 2006 14:22
No should I have?
-
cs02sc
-
- Posts: 4
- Joined: 23. March 2006 17:20
by Oswald » 25. March 2006 13:20
Dear cs02sc!
Good. Please call the following two commands:
echo $TMPDIR
echo $TMP
What output do you get?
Greetings
Oswald
-
Oswald
- Apache Friends
-
- Posts: 2718
- Joined: 26. December 2002 19:51
- Location: Berlin, Germany
- Operating System: Linux
-
by cs02sc » 28. March 2006 10:36
for both of them i get
"root/tmp"
is this correct?
-
cs02sc
-
- Posts: 4
- Joined: 23. March 2006 17:20
by Oswald » 28. March 2006 10:44
Dear cs02sc!
That's the problem. In this case please edit /opt/lampp/etc/my.cnf and search for this line:
#tmpdir = /tmp/
Now, remove the # in front of the line:
tmpdir = /tmp/
Restart XAMPP and everything should work now.
Greetings and good luck
Oswald
-
Oswald
- Apache Friends
-
- Posts: 2718
- Joined: 26. December 2002 19:51
- Location: Berlin, Germany
- Operating System: Linux
-
by cs02sc » 28. March 2006 12:20
it works
I love you very much
-
cs02sc
-
- Posts: 4
- Joined: 23. March 2006 17:20
Return to XAMPP for Linux
Who is online
Users browsing this forum: No registered users and 35 guests