My Google Plus Page

Electricity Bill Calculator

Electricity Bill Calculator

Electricity Bill Cost Calculator. Electricity Usage Consumption Calculator.

Select Country:  
Typical Appliance:
Power Consumption:
Hours Of Use Per Day: Hrs/Day
One Unit Cost (1 kWh ):
 
Electricity Cost Per Day:  
Electricity Cost Per Month:  
Electricity Cost Per Year:  

Note:- 1 Unit = 1 kwh (Kilo Watt Hour)

HTML tutorial

EBC-Ads

Social Message

Social Message
Social Message Useful Health Tips

Friday, November 10, 2017

MySQL Database Purge Binary Logs on any Windows / Linux Platforms

MySQL Database Purge Binary Logs on any Windows / Linux Platforms

The binary log is a set of files that contain information about data modifications made by the MySQL server. The log consists of a set of binary log files.

The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name or date. BINARY and MASTER are synonyms. Deleted log files also are removed from the list recorded in the index file, so that the given log file becomes the first in the list.

How to Delete Binary Logs and Master Logs on Windows Platforms Steps.

First Open MySQL admin command prompt. Type root id and root user password.

Step -1

Show list of binary logs files on MySQL Server.

mysql>SHOW BINARY LOGS;



Step -2

Display master logs file and Delete master log file using command marked Red color in a screenshot.

mysql>SHOW MASTER STATUS;
mysql>RESET MASTER;




Step -3

Delete single binary log file using command marked Red color in a screenshot.




Step -4

Delete all binary log file using command marked Red color in a screenshot. Specify the correct date which dates older files you want to delete.

mysql>PURGE BINARY LOGS BEFORE '2017-10-27 00:00:00';



Step -5

Show list of binary logs files on MySQL Server. Now showing only one, rest all deleted.