Profile Photo

adam10Offline

3 out of 5
1 Rating
  • Profile picture of adam10

    adam10 is feeling Confused

    1 year, 5 months ago

    #mysql_problems
    How to disable MySQL binary logging with log_bin variable ???

    Profile Photo liked this
    2 Comments
    • If you are not replicating, you can disable binlogging by changing your my.ini or my.cnf file. Open your my.ini or /etc/my.cnf (/etc/mysql/my.cnf), enter:

      # vi /etc/my.cnf

      Find a line that reads “log_bin” and remove or comment it as follows:

      #log_bin = /var/log/mysql/mysql-bin.log

      You also need to remove or comment following lines:

      #expire_logs_days = 10

      #max_binlog_size = 100M

      Close and save the file. Finally, restart mysql server:

      # service mysql restart

user balance 774 / Points

user badges

Friends

Profile Photo
Mourad ELGORMA
@onlyfor

Groups

Group logo of Linux
Linux
Public Group
Group logo of HCIA
HCIA
Private Group

Media

Onlyfor.tech

FREE
VIEW