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.

Mysql Log

Discussion in 'General Discussion' started by aswin, Sep 19, 2009.

  1. aswin

    aswin Registered

    Joined:
    Sep 19, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hi
    I have a cpanel server with CentOS 5.3-32 and mysql version 5.0.81.. I need to enable mysql general and access log" Found some commands to do this on internet and checked but it didnt work.I had tried adiing these entries to /etc/my.cnf
    err-log=/var/log/mysqld.log
    /var/log/mysqldquery.log
    and restarted mysql but no luck.I have also tried to enable log on runtime by this command
    " "SET GLOBAL general_log = 'ON';
    but it shows an error message " ERROR 1193 (HY000): Unknown system variable 'general_log' "
    is there any solution to this
    :)
     
  2. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    38
  3. aswin

    aswin Registered

    Joined:
    Sep 19, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Thanks :) But is there anyway to enable this log on the current mysql version on my server through WHM? Since this is a live server, i cannot afford to upgrade the mysql, as it may cause a downtime of my sites. Is there any other way to enable the logs... Help is really appreciated;
     
Loading...

Share This Page