A Forensic software to analyze and backup MySQL Logs

Stellar Log Analyzer for MySQL

Stellar Log Analyzer for MySQL is used by Forensic Users, Database Administrators and Recovery Users to convert the unreadable Log File data into readable tabular-format for an in-depth analysis.

  • Research and Audit General, Redo and Binary Logs of MySQL database

  • Provides Pre-Recovery preview of individual Logs for an in-depth analysis
  • Helps in recovery of deleted records
  • Certifies for Critical Forensic Study of MySQL Log Files
  • Supports MySQL 6.x, 5.x, 4.x, and 3.x
  • Is compatible with Windows 10, 8.1, 8, 7, Vista & XP


Key Features:

Extracts and Analyzes the MySQL Logs icon

Extracts and Analyzes the MySQL Logs

Stellar Log Analyzer for MySQL Database is designed to convert the unreadable and inaccessible MySQL Log Files into readable format thus enabling users to research, audit and analyze these log files. The simplified Logs files ensure that Database Forensic users can identify and analyze transactions in a database system that indicate evidence of Suspicious activity. This software also used by Database Administrators and Recovery Users to track the records activity, in case of system-crash, hardware-failure or deletion of data.

Selects Log Files from Different Locations icon

Selects Log Files from Different Locations

The Log Analyzer allows selection of General and Binary files from the location different from Redo file location, with the manual selection option. Redo files for MySQL database are created by default and saved at a specified location but the creation of the General and Binary Log files can be initiated with a command. User can browse to select the desired database from different locations provided the user provides a root folder containing at least one database and ib_logfile for corresponding database.

Provides Preview of Individual Records of Log Files icon

Provides Preview of Individual Records of Log Files

Log analyzer displays a preview of Database Transaction details along with its respective data and allows finding of the object name in the tree view. Enables search for a Query detail corresponding to a particular transaction, thus helping in analyzing a specific data. Also, the users have an option to select and preview the transaction type – Insert, Delete, Update, before saving the log tables data and log transactions.

Supports Separate Log Report  icon

Supports Separate Log Report

The fast scanning Algorithms supports separate Log Report after scanning database. The software provides sorted Tables in tree-view along with total row count detail in each table for all MySQL versions. Support available for native JSON type and functions for working with JSON values, as per MySQL version. This software also provides Data View of the saved File Records.

Restores Objects of Binary, Redo and General Logs  icon

Restores Objects of Binary, Redo and General Logs

Stellar Log Analyzer reads through all three logs - Redo, Binary and General Logs and provide a detailed analysis of Log file transactions as available in MySQL Database. Also provides support for the automatic recreation of a new My SQL Database consisting of all recovered database items.

Multiple Saving Options for Log Transactions & Data icon

Multiple Saving Options for Log Transactions & Data

Enables saving of Log Files in multiple formats, i.e., MySQL CSV, HTML and XLS format. Saves Log Table Data in a Tabular form directly to MySQL server and also as CSV, HTML and XLS formats. Log Transactions are saved in Query-form as CSV, HTML and XLS formats.

Additional Advantages

Ensures Find or Search the Item Function  icon

Ensures Find or Search the Item Function

Users have the option to select transaction type – Insert, Delete, and Update to find or search the items available in that transaction type. An added option to apply date range filter on log data and log transactions is also available to analyze the data for a particular period. Further, user can search for ‘Other Transactions’ including the queries performed by MySQL at the backend. Search for a particular Query from the preview available after database conversion.

Support and Compatibility icon

Support and Compatibility

  • Support available for almost all Operating System including the highest Windows 10 till Windows Vista
  • Analyzes database of MySQL 6.0 and below
  • 100 MB of free space and 1 GB memory is sufficient to launch the database on a system
  • Try Stellar Log Analyzer for MySQL to analyze MySQL logs

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

    Software Specifications

    Stellar Log Analyzer for MySQL

    System Requirement

    ProcessorPentium Class

    Operating SystemWindows 10, 8.1, 8, 7, Vista & Windows Server 2008 and above

    Memory1 GB

    Hard Disk100 MB

    Software Delivery

    ElectronicYes

    License & Version

    Technician LicenseYes

    Version1.0

    FAQ's

    By default, Redo files are created and saved at the specified location, but the Binary and General Log files can be imported and saved at preferred location. Perform the below-mentioned steps for manual selection:

    • Go to File Menu and click on the Select option. Select Database Location window opens.
    • From the Select Database Location window, click on 'Manual selection of database(s) to analyze' to enable the Browse button
    • Click on Browse button and Browse for Folder dialog box opens. Select the Folder that contains Binary and Log files of MySQL Database. Click on the Ok button and General, and Binary log Files are selected.

    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.

    There is an option to save Log Transactions and Log Data for a particular Date Range:

    • Select Apply Date Range checkbox and apply Date Filters
    • From the Date Range section, select the Date for which you want to apply Filters
    • Click on Save to save the Log files for that Date Range

    Note: Redo Log Files cannot be saved as per Date Range.

    You May Be Interested in These Items

    Stellar Repair for MS SQL

    Stellar Repair for MS SQL

    Stellar Repair for MS SQL is an enterprise-grade database repair software, highly recommended by MS..

    Read More

    Stellar Repair for MySQL

    Stellar Repair for MySQL

    Stellar Repair for MySQL is a competent tool that fixes MySQL database corruption and performs saf..

    Read More

    Stellar Repair for Oracle

    Stellar Repair for Oracle

    Stellar Repair for Oracle is a reliable database repair tool. It recovers Oracle database componen..

    Read More