Solved

Unable To Enable Binary Log On MySQL 4.1.22

Posted on 2010-11-11
4
992 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now