You may need to analyze your MySQL database logs to identify transactions completed by the database. However, the data held within MySQL logs is unreadable. Stellar Log Analyzer for MySQL helps analyze MySQL logs, Redo, Binary, and General Logs. It then helps to view and save log data and log transaction in a readable format.
Manually analyzing MySQL logs containing thousands of entries to find anomalies in database can be challenging. With Stellar Log Analyzer for MySQL software, you can perform forensic analysis of log files in MySQL Server database. After analysis, the software displays preview of the database log file and all its objects. You can also save the log data in a readable format to find any irregularities in the MySQL database.
Stellar Log Analyzer for MySQL performs forensic analysis of MySQL logs to find out the activities carried out on a database, including events such as deletion of data. This information can be used to recover deleted transaction records. The software does so by allowing you to save log tables data, including deleted records, to MySQL server or other file formats, such as CSV, HTML, or XLS.
Stellar Log Analyzer for MySQL is designed to analyze forensic details of log files of MySQL server database in a simplified manner. It performs analysis of MySQL logs such as Redo Log, General Query Log, and Binary Log. After analysis, the software allows saving Log Data and Log Transaction in a readable format. Thus, enabling the users to research, audit, and analyze these log files. This helps find evidence of any suspicious activity carried out on the database system.
The Log Analyzer allows selection of General and Binary files from the location different from Redo file location. Redo files for MySQL database are created by default and saved at a specified location but the creation of General and Binary Logs can be initiated with a command. User can browse to select the desired database from different locations provided that the user provides a root folder containing at least one database and ib_logfile for corresponding database.
The Log Analyzer displays preview of databases and tables of MySQL log file in a tree-view structure. You can view the content of tables by selecting a particular table. It also allows you to view complete transactions and log details of any MySQL Log file. You can view the transactions details such as Transaction Type, Transaction Name, Transaction Time, Query, etc. You can select and preview the Transaction Type – Insert, Delete, Update, before saving the log tables data and log transactions.
The software provides option to save log report of the MySQL log file analysis process, after scanning the database. The log report can be used at a later stage to analyze the contents of the process. It contains detailed information about the analysis process, such as start and end time of scanning process, selected log file name, log file size, total number of transactions present, etc.
Stellar Log Analyzer scans MySQL logs, such as Redo, Binary, and General Logs, and provides a detailed analysis of log file transactions of the selected MySQL database. After analysis, the software displays preview of the database log file and its objects. You can select the objects and save them in a newly created folder at the same location as MySQL database.
The software allows saving logs in multiple formats, such as MySQL, CSV, HTML, and XLS format. You can save log tables data in a tabular form directly to your MySQL server or save the tables data in CSV, HTML, or XLS file format. The software allows saving log transactions in only CSV, HTML and XLS format.
After completion of the analysis process, you can use the Find option in the preview window to search for particular items. You can also apply date filters on log transactions and log transaction data to analyze the data for a particular time period. Further, you can search for ‘Other Transactions’, including the queries performed by MySQL at the backend. You can also search for a particular Query from the preview available after database conversion.
The Stellar MySQL Log Analyzer software can work with almost all operating systems, including the latest Windows 10 till Windows 7. Further, it supports analyzing logs of MySQL 8.0 and below versions.
Step 1: This is the main interface of Stellar Log Analyzer for MySQL.
See all Screenshots
*Free download allow to see preview of complete details related to the transactions.
*Download the free trial version on your Desktop or Laptop to scan & preview your recoverable items.
The demo version of the software helps analyze and preview MySQL logs. To save analyzed file, you need to activate the software.
By default, Redo files are created and saved at the specified location, but the Binary and General Logs can be imported and saved at preferred location. Perform the below-mentioned steps to manually save the Binary and General Logs at a desired location:
In most cases, transaction data is visible at the bottom of the interface. In case the pane is not visible, then enable it by selecting the Data View checkbox in View section of File Menu.
The application setup provides the necessary Drivers to be installed. Download these Drivers to establish a connection with MySQL.
Following are the steps to save Log Transactions and Log Data for a particular Date Range:
Years of Experience