Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2011
    india- new delhi

    Unanswered: how to see mysql log file..

    Good Afternoon All,
    I read out that Mysql server create a log file where he keep record of all activities- like when and what query execute. I want to see it, Can anybody tell me where it exist in my system? how can i read it?
    basically i need to make backup of database with different input [ backup between two dates] so i think i need to use log file here, that's why i want to go for it...
    when i wondered i got that binary log file keep username and password information too[ if any query require of this] so it is very secure, not easy seen it!!
    i am a admin of my system , how i can see it? when i try to open var/log/mysql.log it is empty....

    when i wondered a lot i got that there are a my.cnf file, and i should need to set a path of log , i create a file a.log on the desktop ,i open the my.cnf and change the path [ visible next time] and then when i execute the query a.log still emply.
    one thing is more logically the path of log is var/log/mysql/mysql.log but when i m trying to open mysql folder, it flashed a messege not accessible by me. how can i open it? how i can see the log file.
    Thanking you in advance....
    Last edited by rohitamitpathak; 03-28-11 at 02:17. Reason: i got something more
    Amit Pathak
    S/w Developer
    Zero Systems Pvt Ltd..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts