SQL DM for MySQL uses SQLite for storing all the data. With 'data' - we are referring to:

There is one of each of those database files for every connection except for events.data that is common to all the servers.

Where can you find this data?

Below, you can find the default paths for the data collected by SQL DM for MySQL for the first connection created by SQL DM for MySQL:

In windows systems

 C:\ProgramData\Webyog\MONyog\Data\0001

In Linux systems

-   RPM: /usr/local/MONyog/data/0001
-   Tar: In the same directory where MONyog was 'untarred'.

How to view existing schema and data?

You can view the existing schema and data by using a SQLite client. In addition to the official SQLite command-line client there are simple GUI clients available (This is a plugin for the Firefox browser and works on all platforms, but there are more GUI clients available for download - mostly for Windows. Most Linux distributions ship with some database client software that handles SQLite).

Schemas may be subject to change. We may add/remove columns, change data types, change indexes etc. with new releases. When we do that, you can check-in release notes and you can open the database with the tools mentioned to see the columns.



| | | | |