Stellar Log Analyzer for MySQL

Forensic Software to Analyze MySQL Logs

An advanced software designed for database administrators to perform detailed analysis of log files transactions of MySQL Server database. The software analyzes the forensic details of Redo, General, and Binary logs to find out anomalies in MySQL database. It helps you preview transaction type (insert, delete, & update), transaction time, transaction name, table name, and query.

  • Performs forensic analysis of Redo, General, & Binary files logs
  • Supports recovery of deleted transaction records
  • Supports MySQL 8.x, 6.x, and 5.x
*Free download allow to see preview of complete details related to the transactions.

Stellar Log Analyzer for MySQL

When to Use Stellar Log Analyzer for MySQL?

Need to Analyze MySQL Logs?

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.

Unable to Find Anomalies in MySQL Database?

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.

Need to Recover Deleted Transaction Records?

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.

Key Features

Extracts and Analyzes MySQL Logs icon

Extracts and Analyzes MySQL Logs

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.

Select Logs from Different Locations icon

Select Logs from Different Locations

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.

Previews Log Records and Transaction Log Data icon

Previews Log Records and Transaction Log Data

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.

Saves Log Report  icon

Saves Log Report

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.

More Awesome Features

Restores Objects of Binary, Redo, and General Logs  icon

Restores Objects of Binary, Redo, and General Logs

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.

Multiple Saving Options for Log Transactions & Data icon

Multiple Saving Options for Log Transactions & Data

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.

Option to Find Particular Items in Log File  icon

Option to Find Particular Items in Log File

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.

Support and Compatibility icon

Support and Compatibility

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.

Product Tour for Stellar Log Analyzer for MySQL

Technical Specifications

About Product


Stellar Log Analyzer for MySQL

Version

2.0.0.0

Release Date

January, 2021

License

Multiple Users

Version Support

MySQL 8.x, 6.x, and 5.x

Edition

Technician

End User License Agreement

EULA

Language Supported

English

System Requirements


Stellar Log Analyzer for MySQL

Processor

Intel-compatible (x86, x64)

Operating System

Windows 10, 8.1, 8, 7, & Windows Server 2008 and above

Memory

4 GB minimum (8 GB recommended)

Hard Disk

250 MB for installation files

Download Guides


TRY IT OUT FOR FREE

Start Using Stellar Log Analyzer for MySQL Today With Our Free Trial.

*Free download allow to see preview of complete details related to the transactions.

Start Using Stellar Photo Recovery Today With Our Free Trial

FAQ

A.

The demo version of the software helps analyze and preview MySQL logs. To save analyzed file, you need to activate the software.

A.

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 the Select Log File section of Log Detail dialog box, click Select against the desired log file.
  • Browse and select the General or Binary Log file you want to analyze.

A.

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.

A.

The application setup provides the necessary Drivers to be installed. Download these Drivers to establish a connection with MySQL.

A.

Following are the steps to save Log Transactions and Log Data for a particular Date Range:

  • In the Save dialog box, click the Select date range checkbox.
  • Specify the From and To dates.
Note: Redo Logs cannot be saved as per Date Range.