Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

[navido]

I get the error:
Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28)

This appears at www.fotoexperten.no

As i have understood this has to do with filled up disc place. I have deleted the /tmp folder in my root folder but still i get this message. Can anyone help me? Do i have to contact my host to let theme free up space?

[Ajeh]

Yes. check with your hosting provider as they need to deal with the server tmp folder, which is different than the one you deleted ...

I am also assuming that by saying you deleted your /tmp directory you really mean you "cleaned it out" and it is still there ...

[navido]

Yes. check with your hosting provider as they need to deal with the server tmp folder, which is different than the one you deleted ...

I am also assuming that by saying you deleted your /tmp directory you really mean you "cleaned it out" and it is still there ...

The folder itself is there but the content of the temp folder is empty. It shouldnt be any problem right? I took a backup of it though.

[Ajeh]

Zen Cart does not use the /tmp directory for anything ... it is more or less if there needs to be a /tmp then you want to ensure it is still there for something else on your site that does use it ...

[RodG]

Do i have to contact my host to let them free up space?

Yes. In fact this is the only thing you can do. The problem is entirely out of your control.

Cheers
Rod

[allthingsidLeroy]

Sometimes hosting services that offer jailed access to the command line don't revoke the 'mount' command. If you need access and are doing this through the command-line, you might try creating a directory in your home folder and binding a different part of the filesystem (in this case /tmp) to that folder. Here's an example:

mkdir tempFolder/
mount --bind /tmp tempFolder/

Most likely you won't have permissions to do this, but it is worth a shot.

[RodG]

Sometimes hosting services that offer jailed access to the command line don't revoke the 'mount' command. If you need access and are doing this through the command-line, you might try creating a directory in your home folder and binding a different part of the filesystem (in this case /tmp) to that folder. Here's an example:

mkdir tempFolder/
mount --bind /tmp tempFolder/

Most likely you won't have permissions to do this, but it is worth a shot.

Can I

mkdir tempFolder/
mount --bind /etc tempFolder/

So I can read the passwd file ?

[allthingsidLeroy]

So I can read the passwd file ?

It really depends on how the permissions are set in the /etc folder. This whole scenario requires a hosting service which does not expect a user to have access to the root folders of a system. Most hosting services will properly jail a user to their home directory with little-to-no chance of accessing other parts of the system, but many will not.

Like I said, it's worth a shot, but it likely isn't going to happen.