Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
[mysqld]
datadir=/db_vol/datadir
socket=/var/lib/mysql/mysql.sock
port=3306
server_id=1
log-bin=/db_vol/log/mysql-bin.log
binlog-do-db=mydb

When I try to start MySQL, I get an error that says MySQL Daemon failed to start.. If I comment out the log-bin line then it loads fine. I'm trying to set up replication so I think I need log-bin, but I'm not sure.

share|improve this question
2  
What does the MySQL error log say? –  EEAA Apr 26 '13 at 0:03
    
Most likelt this is because mysql can't write to /db_vol/log/mysql-bin.log. Look in your error log, dev.mysql.com/doc/refman/5.5/en/error-log.html –  sciurus Apr 26 '13 at 3:35
add comment

1 Answer

up vote 1 down vote accepted
  1. Does the folder /db_vol/log/ exist?

  2. Do the permissions /db_vol/log/ allow write access? e.g. is the user / owner matching the mysql account and the account(s) have write access?

If your mysql user account was mysql, you could run this:

chown mysql:mysql /db_vol/log/

and then

chmod 770 /db_vol/log/

share|improve this answer
add comment

Your Answer

 
discard

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.