Skip to content

Instantly share code, notes, and snippets.

@bosunolanrewaju

bosunolanrewaju/my.cnf

Created June 28, 2018 09:18
Show Gist options
  • Save bosunolanrewaju/e7cf4b218e12f5e2b25b7b9e1c7f9f51 to your computer and use it in GitHub Desktop.
Save bosunolanrewaju/e7cf4b218e12f5e2b25b7b9e1c7f9f51 to your computer and use it in GitHub Desktop.
Download ZIP
Enable binlog for mysql
Raw
my.cnf
#Enabling binlog inside mysql configuration file
log-bin=bin.log
log-bin-index=bin-log.index
max_binlog_size=100M
binlog_format=row
socket=mysql.sock
Raw
mysql_binlog_sql.sql
# Check Binlog Status
select variable_value as "BINARY LOGGING STATUS (log-bin) :: "
from information_schema.global_variables where variable_name='log_bin';
# Check Binlog format
select variable_value as "BINARY LOG FORMAT (binlog_format) :: "
from information_schema.global_variables where variable_name='binlog_format';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment