Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Dec 292010

Enable MySQL binary log (bin log)


The MySQL binary log contains the changes to the database in binary log format. They are useful for

  1. Database recovery
  2. Replication

To enable it, edit the MySQL configurations, e.g. /etc/my.cnf


Don't forget to restart MySQL to take effect.

# /sbin/service mysqld restart

  One Response to “Enable MySQL binary log (bin log)”

  1. [...] you have enabled the binary log in your MySQL server, you need to be aware that the log will use up the space of your local disk [...]

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>