Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Code Block
themeConfluence
 C:\ProgramData\Webyog\MONyog\Data\0001

In Linux systems

Code Block
themeConfluence
-   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

Newtab2
aliasSQLite Manager
url https://addons.mozilla.org/en-US/firefox/addon/5817
(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).

...