Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

1 Can't create/write to file '/tmp/#sql_17bf_0.MYD' (Errcode: 17)

Discussion in 'General Discussion' started by lxjtian, May 7, 2011.

  1. lxjtian

    lxjtian Registered

    Joined:
    Apr 5, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    hello:

    always happen this problem, How to resolve this complete?

    when showing this erro, I login server with root, delete /tmp/#sql_17bf_0.MYD' , anything is fine after delete this file.
    1 Can't create/write to file '/tmp/#sql_17bf_0.MYD' (Errcode: 17)
     
  2. d_t

    d_t Well-Known Member

    Joined:
    Sep 20, 2003
    Messages:
    242
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Bucharest
    /tmp is usually mount as tmpfs and is limited in site (to shared memory size). If you have very big temporarely files in mysql you can move mysql temp to a distinct folder. Ex:
    Code:
    mkdir /var/tmpmysql/
    chown mysql:mysql /var/tmpmysql/
    edit /etc/my.cnf and add
    Code:
    tmpdir=/var/tmpmysql/
    then restart mysql.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice