BinLogs can be read in couple of ways. Here it is described in 3 ways:
- Login to phpMyAdmin.
- Go to “Binary Log” tab
- Select Binary Logs to view
- Click GO
By default this would show 30 lines. So if you want to customize, click on EDIT and change the query according to your need.
Using SQL Query:
Determine existing binary logs on the system
- From MySQL run the following for any existing binlog to read. I’ll try for 100 lines.
Using UNIX Commands:
- From OS, we can directly read the binlogs. Here is how:
- This can be modified and run with unix commands for customized reports.