Solved

Unable To Enable Binary Log On MySQL 4.1.22

Posted on 2010-11-11
4
1,016 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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

634 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