{"id":13413,"date":"2023-12-23T19:10:51","date_gmt":"2023-12-24T02:10:51","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=13413"},"modified":"2024-01-09T19:32:56","modified_gmt":"2024-01-10T02:32:56","slug":"mysql-disable-binary-logs","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/mysql-disable-binary-logs\/","title":{"rendered":"How to Disable Binary Logs in MySQL"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to disable binary logs using the skip-log-bin option in the MySQL configuration file.<\/p>\n\n\n\n

First, open the terminal and connect to the MySQL server<\/a>:<\/p>\n\n\n

myql -u root -p<\/code><\/span><\/pre>\n\n\n
Second, check if the binary logging is enabled:<\/p>\n\n\n
show global<\/span> variables like 'log_bin'<\/span>;<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+---------------+-------+\n| Variable_name | Value |\n+---------------+-------+\n| log_bin       | ON    |\n+---------------+-------+\n1<\/span> row in<\/span> set<\/span> (0.00 sec)\n<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
The log_bin<\/code> is ON<\/code>, meaning that the binary logging is enabled.<\/p>\n\n\n\n
Third, exit the mysql client program:<\/p>\n\n\n
exit<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
[mysqld]\n# ...<\/span>\n# disable binary log<\/span>\nskip-log-bin<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
sudo<\/span> systemctl<\/span> restart<\/span> mysql<\/span>.service<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
Note that you need to replace the mysql.service<\/code> with the actual MySQL service name in your system.<\/p>\n\n\n\n
Sixth, log in to the MySQL server:<\/p>\n\n\n
mysql -u root -p<\/code><\/span><\/pre>\n\n\n
Seventh, show the variable log_bin<\/code>:<\/p>\n\n\n
show global<\/span> variables like 'log_bin'<\/span>;<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+---------------+-------+\n| Variable_name | Value |\n+---------------+-------+\n| log_bin       | OFF   |\n+---------------+-------+\n1<\/span> row in<\/span> set<\/span> (0.00 sec)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
The log_bin<\/code> variable is OFF<\/code>, meaning that the binary logging is disabled.<\/p>\n\n\n\n
If you attempt to display the binary logs, MySQL will issue an error:<\/p>\n\n\n
show binary logs;<\/code><\/span><\/pre>\n\n\n
Error:<\/p>\n\n\n
ERROR 1381 (HY000): You are not using binary logging<\/code><\/span><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the skip-log-bin<\/code> option in the MySQL configuration file to disable the binary logs in MySQL; restart MySQL to apply the change.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t
Fifth, save the my.cnf<\/code> file and restart the MySQL server<\/a>:<\/p>\n\n\n
Fourth, edit the MySQL configuration file<\/a> (my.cnf<\/code>) using a text editor for example nano<\/code>, and place the skip-log-bin<\/code> option in the [mysqld]<\/code> section:<\/p>\n\n\n