Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to enable binary log in order to create master slave for my DB.
MySQL version is 5.1.41-3ubuntu12.10-log
I have added this to my.cnf

log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days  = 1
max_binlog_size   = 100M


$ ls -l /var/log/mysql/mysql-bin.log
-rw-r--r-- 1 mysql root 0 2011-07-06 17:17 /var/log/mysql/mysql-bin.log

Now when I try to stop/start MySQL the starting process goes forever and I was forced to comment those entries in my.cnf to start MySQL again.

Anybody faced such problem? Any idea is highly appreciated.

share|improve this question
Do you see anything of use in the server log mysqld.log? – Michael Jul 6 '11 at 17:47
If you can, > 'strace -Ff -v /etc/init.d/mysql > start' and post output please. – Khushil Jul 6 '11 at 19:45

Do you have a host_name-bin.index file created? If not, specify log-bin-index as well.

share|improve this answer
up vote 0 down vote accepted

Thanks guys for your help
it was permission of the log directory itself. i have changed it to be

drwx------ 7 mysql mysql  4096 2011-07-06 20:06 mysql

it was

drwx------ 7 root root  4096 2011-07-06 20:06 mysql
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.