Mysql Open table error - Printable Version

Mysql Open table error - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: Mysql Open table error (/thread-4303.html)

Pages: 1 2

Mysql Open table error - homodo - 09-19-2008 05:40 PM

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

RE: Mysql Open table error - joximu - 09-19-2008 05:42 PM

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

RE: Mysql Open table error - homodo - 09-19-2008 05:46 PM

how usr the Berechtigungen auf /tmp

RE: Mysql Open table error - BeNe - 09-19-2008 05:48 PM

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

RE: Mysql Open table error - homodo - 09-19-2008 05:50 PM

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

RE: Mysql Open table error - homodo - 09-19-2008 05:58 PM

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

RE: Mysql Open table error - BeNe - 09-19-2008 06:06 PM

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

RE: Mysql Open table error - homodo - 09-19-2008 06:21 PM

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

RE: Mysql Open table error - joximu - 09-19-2008 06:31 PM

Code:

ls -lad /tmp

RE: Mysql Open table error - homodo - 09-19-2008 06:33 PM

ls: /tmp: No such file or directory