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.

Log Mysql

Discussion in 'General Discussion' started by rorobobo, Dec 27, 2005.

  1. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Hello

    I want to activate log mysql, how ?

    Regards
     
  2. WebScHoLaR

    WebScHoLaR Well-Known Member

    Joined:
    Dec 14, 2005
    Messages:
    511
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Planet Earth
    MySQL error log file is located at /var/lib/mysql/hostname.err.Did you checked that file that MySQL server is not making entries to this log file?
     
  3. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    There's also a chance that the error log is pointing elsewhere. You should check /etc/my.cnf if it's not where WebScHoLaR has said.
     
  4. toma1708

    toma1708 Active Member

    Joined:
    Aug 30, 2001
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    MySQL log

    You should edit the my.cnf file

    pico /etc/my.cnf

    and add/uncomment the line below in the [mysqld] section

    log=/var/log/mysqld.log

    If you want to check it

    tail -f /var/log/mysqld.log

    Please make sure to comment that line when you no longer need it because you risk to have the /var partition filled up.

    Catalin
     
Loading...

Share This Page