The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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 Member

    Joined:
    Apr 5, 2011
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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:
    243
    Likes Received:
    1
    Trophy Points:
    18
    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