Dennis’s Weblog

Mysql – Log – Bug

Posted on: October 15, 2008

These two days I encounter a problem that when I query data from database, and update them, I cann’t get the query log.

Since that I got to find a method to log it.

And mysql has  such a build-in function, So i use it, here is the usage:

Windows:

1.Go to the bin folder.

2.mysqld-nt –install  mysql –log=c:\mylog.log; Here must have the “mysql” or it will not work!!!

Ubuntu

I still cann’t find out the solution. I wasted two days on it , just to find that it is a bug of mysql

http://bugs.mysql.com/bug.php?id=17368

Conclusion: When you get to do something, but the function doesn’t work. Please let yourself calm down, and extract the point of the problem! You should also suspect whether there is a bug in this system instead of your fault? Since that you can find out the solution quickly. In case there is a bug you will not get stuck.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: