Solved

Unable To Enable Binary Log On MySQL 4.1.22

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
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://…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 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