- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 22:30:24
- Related Questions & Answers
- Show MySQL host via SQL Command?
- How to redirect if JavaScript is not enabled in a browser?
- Is INNODB enabled by default in MySQL?
- How to enable MySQL Query Log?
- What is the use of update command in SQL?
- How do I know if a MySQL table is using myISAM or InnoDB Engine?
- How do I know which MongoDB version is installed using the Command Line?
- How can I to know if my database MongoDB is 64 bits?
- How can we transfer information between MySQL and data files through command line?
- How can we establish MySQL database by using MySQL binary at command prompt?
- How to check if Location Services are enabled in iOS App?
- How to check if Location Services are enabled in Android App?
- Checking if a button is enabled or disabled in SAP Application
- How to find out if the GPS of an Android device is enabled or not?
- How to know if your child have allergy symptoms?
Advertisements