Stellar Log Analyzer for MySQL is a powerful software for in-depth analysis of MySQL log files. The tool previews extensive details of the database transactions and respective data after analyzing the log files. It provides the option to filter the log table data and log transactions based on the date range and can also search for object names in Tree view format. The software can save the log table data to MySQL Server and supports CSV, HTML, and XLS file formats. Stellar Log Analyzer for MySQL allows the user to select the transaction type, including Insert, Delete, or Update while saving the log tables data and log transactions. It automatically creates a new database comprising all the recovered items and supports native JSON type and functions to work seamlessly with the JSON values of the latest MySQL version. 

Key features
Forensic Analysis of Log Files
The software analyzes all the transactions, including the Insert, Delete, and Update operations performed on the server. After completing the analysis, the tool allows the user to select and scan the Redo, Binary, and General Log files, displaying a preview of the log file data to gather the forensic details.

Previews the Database Log Files
The tool displays an enhanced preview of the log file data, including the databases and tables, in a Tree format. It allows sorting the information as per the Transaction Type, Transaction Name, Table Name, and Query. The user can view granular details of any transaction by clicking the tables listed in the left pane.

Finds the Specific Database Items 
The software provides a search bar to locate specific items displayed in the Tree view. The user needs to enter the item name and click the Find button to locate the item. Further, Match case and Match whole word options are available to narrow down the search.  

Saves the Log File Data
The tool can save the log file data as Log Record and Log Transactions. It can save the Log Record to a MySQL database or in CSV, HTML, and XLS file formats. For Log Transactions, the tool supports CSV, HTML, and XLS file formats. The user can also choose the date range to save the data for a specific duration.

Saves the Log Report
Stellar Log Analyzer for MySQL allows the user to save the log reports of the analysis tasks, accessible through the Log Report option at the bottom of the user interface.  The software provides sorted tables in tree-view and the total row count details in each table across all MySQL versions.  

Supports Native JSON Type
The software supports native JSON type to allow working with the JSON values associated with the latest version of MySQL Server. The feature helps in seamless transmission and analysis of the data objects to the new database version installed on the user’s machine.