Image

How to disable log-bin on Directadmin

Billing Area



How to disable log-bin on Directadmin

Login to MySQL

mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2`


Remove existing files from server based on time.

PURGE BINARY LOGS BEFORE NOW() - INTERVAL 30 MINUTE;


Check if log-bin exists

SHOW BINARY LOGS;

Disable log-bin
 

nano /etc/my.cnf
skip-log-bin
service mysql restart
Please rate this article to help us improve our Knowledge Base.

2 0