Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to know if MySQL binary log is enabled through SQL command?
to know if MySQL binary log is enabled through SQL command, you can use show variables command.
The syntax is as follows
show variables like ‘yourPatternValue’;
In place of ‘yourPatternValue’, you can use log_bin to check the binary log is enabled using SQL command show.
The query is as follows
mysql> show variables like 'log_bin';
The following is the output that displays whether it is enabled or not
+---------------+-------+ | Variable_name | Value | +---------------+-------+ | log_bin | ON | +---------------+-------+ 1 row in set (0.03 sec)
Updated on: 30-Jul-2019
4K+ Views
Advertisements