backup problem and all website cannot view cant write tmp folder

[msn512msn]

backup problem and msql cannot write to temp folder

after backup will become this ( this problem alreadly few time)





and then it will cause all website cannot go in
a sample with a phpwebshop will show this message


MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `cocodo4_sfce`.`dfgre_brand`AS b, `cocodo4_sfce`.`dfgre_goods` AS g WHERE g.brand_id = b.brand_id AND is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC LIMIT 11 ) [2] => Array ( [error] => Can't create/write to file '/tmp/#sql_31e_0.MYD' (Errcode: 17) ) [3] => Array ( [errno] => 1 ) )



anyone how to solve this problem? don now what happen ... s
and after i restart msql and this problem solve but if after few day it problem will comeback again

 

[Greenhost]

My be this happen because of maximum allowed packet size in MySQL.

To solve, add in the [mysqld] section in yourphp.ini: max_allowed_packet=100M and restart MySQL

Check the other thread, might will be helpful:
http://drupal.org/node/1014172

 

[msn512msn]

hi is edit mysql file or phpini (in file editor of da)?
i find phpini no mysqld section only msql

 

[zEitEr]

There should be [MySQL] and [MySQLi] sections in every php.ini provided by directadmin.

To get ability to edit /etc/my.cnf in directadmin you should follow this guide and add the file /etc/my.cnf into /usr/local/directadmin/data/templates/custom/edit_files.txt (firstly copy /usr/local/directadmin/data/templates/edit_files.txt to /usr/local/directadmin/data/templates/custom/edit_files.txt)

http://www.directadmin.com/features.php?id=576