Mysql Open table error

[homodo]

Open table error
#1 - Can't create/write to file '/tmp/#sql_98e_0.MYI' (Errcode: 13)

[joximu]

"Write permissions on /tmp" or "enough space on /tmp"???

[homodo]

how usr the Berechtigungen auf /tmp

[BeNe]

Please post the output:

Code:

df -h

Permissions on /tmp should be:

Code:

drwxrwxrwt    5 root root  4096 Sep 19 07:45 tmp

Greez BeNe

[homodo]

Filesystem Size Used Avail Use% Mounted on
/dev/sda1 141G 3.2G 131G 3% /
tmpfs 1.5G 0 1.5G 0% /lib/init/rw
udev 10M 72K 10M 1% /dev
tmpfs 1.5G 0 1.5G 0% /dev/shm

[homodo]

Filesystem Size Used Avail Use% Mounted on
/dev/sda1 141G 3.2G 131G 3% /
tmpfs 1.5G 0 1.5G 0% /lib/init/rw
udev 10M 72K 10M 1% /dev
tmpfs 1.5G 0 1.5G 0% /dev/shm
6do:~# drwxrwxrwt 5 root root 4096 Sep 19 15:56 tmp
bash: drwxrwxrwt: command not found

[BeNe]

Code:

/dev/sda1 141G 3.2G 131G 3% /
tmpfs 1.5G 0 1.5G 0% /lib/init/rw
udev 10M 72K 10M 1% /dev
tmpfs 1.5G 0 1.5G 0% /dev/shm

This is OK - there is enough space free.

Code:

6do:~# drwxrwxrwt 5 root root 4096 Sep 19 15:56 tmp
bash: drwxrwxrwt: command not found

This was not a command - it was an output from a /tmp direcotry.
So you can compare it with yours.

Greez BeNe

[homodo]

drwxr-xr-x 2 server server 4096 2008-09-14 22:01 .
drwxr-xr-x 4 root root 4096 2008-09-14 21:49 ..
-rw------- 1 server server 78 2008-09-19 04:12 .bash_history
-rw-r--r-- 1 server server 220 2008-09-14 21:37 .bash_logout
-rw-r--r-- 1 server server 414 2008-09-14 21:37 .bash_profile
-rw-r--r-- 1 server server 2227 2008-09-14 21:37 .bashrc
# drwxr-xr-x 4 root root 4096 2008-09-14 1613 tmp
bash: drwxr-xr-x: command not found

[joximu]

Code:

ls -lad /tmp

[homodo]

ls: /tmp: No such file or directory