SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Logging Queries

  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2001
    Location
    London, UK
    Posts
    62
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Logging Queries

    Hi,

    Is it possible to log or find out the queries being sent to a MySQL server?


    Thanks,

    Rob

  2. #2
    SitePoint Addict
    Join Date
    May 2004
    Location
    .
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ilya Devyatovsky
    ThinkHost, Inc.
    Wind/solar powered web hosting - 6 months free!

  3. #3
    SitePoint Member
    Join Date
    Jun 2004
    Location
    us of a
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you want to log only the queries that modify/update..data then you can use following option in my.ini

    --log-bin

    I use mysqlFront too and it does the job. Noticed one gotcha long ago that when you copy and paste table using mysqlfront, it fails to copy/add 'autoincrement' in new tables field defination. Hope they fixed it

    - slamdunkinpoolJAMyahooDOTcom ( remove 'JAM' )


Bookmarks

Posting Permissions

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