Solved

Unable To Enable Binary Log On MySQL 4.1.22

Posted on 2010-11-11
4
1,012 Views
Last Modified: 2012-06-21
Greetings,

I have been unable to enable binary log for MySQL 4.1.22 on linux OS. I am using the following variable:

log-bin=/mysql/log/mysql-bin

Please help
0
Comment
Question by:Omega002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 3

Accepted Solution

by:
dnadavis earned 500 total points
ID: 34117618
add this to your /etc/my.cnf file(mysql conf file)

log-slow-queries =/var/log/log-slow-queries.log(path to the file where to store the slow queries .Give 777 permission to this file chown 777 <filename>)
long_query_time = 2  ( if it is 2 mysql will log all those queries taking more than 2 ms )
log-queries-not-using-indexes  ( if you add this too in your conf file it will consider the queries that are not using indexes )

restart mysqld .
Go to your mysql .
try this there
mysql>show global variables ;
check  whether log_slow_queries  =  ON.
if it is det then you can start querying and if any slow queries comes you can see them in the log file you mentioned in your my.cnf file.
0
 

Author Comment

by:Omega002
ID: 34123710
I just need to enable it so the following variable is on:

log_bin  ON


0
 

Author Comment

by:Omega002
ID: 34123988
hello hello are you there? I just need to turn on Binary loggin which should show the following value if enable:

log_bin ON


How do I enable Binary logging on MySQL 4.1.22? Please help.
0
 

Author Closing Comment

by:Omega002
ID: 34431670
Good suggestion
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question