Solved

Cant start binary logging with mysql 5.1 community editon

Posted on 2014-10-24
1
281 Views
Last Modified: 2014-10-30
I'm trying to start binary logging using MySQL 5.1-73 community edition.  I'm following the documentation and the only thing that appears to be needed is adding --log-bin="c:\MySQL logs\bin_log" to the startup parameters.  (On a side note I couldn't set these in services, I had to edit the registry).  However it won't start up.  I've tried copying the command string out of the registry to the command prompt and running it.  It works without the log-bin argument, but fails to start with it applied.

The command line looks like:
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" --bin-log="c:\MySQL logs\bin_log" MySQL

It does get far enough to create an index file.  There is one new log entry in the event log:
Event id 100: Aborting

Not terribly useful.

The docs says that there are reasonable defaults for all of the other options, and I'm fine with those.
We are using INNODB and the transaction isolation level is set to repeatable-read.

Am I doing something wrong here, or is this a function that's not available in my situation?
0
Comment
Question by:geekdad1
1 Comment
 
LVL 7

Accepted Solution

by:
Stampel earned 500 total points
ID: 40403852
Edit "C:\Program Files\MySQL\MySQL Server 5.1\my.ini",  and set this into the mysqld section :
server-id=1
log-bin=mysqld-bin
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

930 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

13 Experts available now in Live!

Get 1:1 Help Now