Binary log management in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to show the current binary log files in MySQL.

MySQL

SHOW [1];

Drag options to blanks, or click blank then click option'

ATABLES

BDATABASES

CBINARY LOGS

DSTATUS

Attempts:

3 left

💡 Hint

Common Mistakes

Using SHOW DATABASES instead of SHOW BINARY LOGS.

Using SHOW TABLES which lists tables, not logs.

The command SHOW BINARY LOGS; lists all binary log files currently available on the MySQL server.

2fill in blank

medium

Complete the code to enable binary logging in MySQL configuration.

MySQL

[mysqld]
[1]=ON

Drag options to blanks, or click blank then click option'

Alog_bin

Bbinlog_format

Cserver_id

Dskip_log_bin

Attempts:

3 left

💡 Hint

Common Mistakes

Using binlog_format which sets format but does not enable logging.

Using skip_log_bin which disables binary logging.

Setting log_bin=ON in the MySQL configuration file enables binary logging.

3fill in blank

hard

Fix the error in the command to purge binary logs older than a specific date.

MySQL

PURGE BINARY LOGS TO '[1]';

Drag options to blanks, or click blank then click option'

Abinlog.000010

Bmysql-bin.000010

Cmysql_bin_000010

Dmysql-bin-000010

Attempts:

3 left

💡 Hint

Common Mistakes

Using dashes or underscores instead of dots in the file name.

Using incomplete or incorrect file name formats.

The correct syntax requires the exact binary log file name with dot separators, like mysql-bin.000010.

4fill in blank

hard

Fill both blanks to set the binary log format and server ID in MySQL configuration.

MySQL

[mysqld]
binlog_format=[1]
server_id=[2]

Drag options to blanks, or click blank then click option'

AROW

BSTATEMENT

C12345

DON

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'ON' for binlog_format instead of a valid format.

Using non-numeric values for server_id.

binlog_format can be set to 'ROW' for row-based logging, and server_id must be a unique number like 12345.

5fill in blank

hard

Fill all three blanks to create a command that shows the status of binary logging and the current binary log file.

MySQL

SHOW [1] LIKE '[2]';
SHOW MASTER [3];

Drag options to blanks, or click blank then click option'

ASTATUS

Blog_bin

DLOGS

Attempts:

3 left

💡 Hint

Common Mistakes

Using SHOW LOGS which is not a valid MySQL command.

Using incorrect filter strings in LIKE clause.

The first command SHOW STATUS LIKE 'log_bin'; checks if binary logging is enabled. The second command SHOW MASTER STATUS; shows the current binary log file and position.