I have KILLED my server, PLEASE help me...

[ThisIsSparta]

I have deleted and re-created the folder /tmp/ in my server to free some space, but now ALL my sites are down and if I access to plesk I see this errore:

ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_39d_0.MYI' (Errcode: 13) (Pdo.php:234)

Please, someone have any idea??? I'm disperate...

 

[ThisIsSparta]

If I open a website in this server I see:

"Can't create/write to file '/tmp/#sql_39d_0.MYI' (Errcode: 13) SQL=SELECT * FROM [..]"

I have try command stat:

[root@s17857679 ~]# stat /tmp
  File: `/tmp'
  Size: 4096            Blocks: 8          IO Block: 4096   directory
Device: 900eh/36878d    Inode: 699040458   Links: 2
Access: (0755/drwxr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
Access: 2015-03-25 19:10:15.000000000 +0100
Modify: 2015-03-25 19:10:08.000000000 +0100
Change: 2015-03-25 19:10:08.000000000 +0100

 

[ThisIsSparta]

I have solved the problem

chmod 1777 /tmp
/etc/init.d/mysqld restart

 

[UFHH01]

Hi ThisIsSparta,

you could have found the solution as well here:

Plesk cannot be accessed because of the error "Can't create/write to file" ( KB - article 111 35 )​