What is Monyog's Data?
Monyog uses SQLite for storing all the data. With 'data' - we are referring to:
- Data collected from MySQL servers (stored in the database file mysql.data).
- Data collected from the operating system (currently available for Linux only, stored in the database file system.data).
- Data captured from 'sniffing' (stored in the database file sniffer.data).
- Data captured from 'CSO's (stored in database file udo.data).
- Data captured for events (stored in events.data)
- Also, the connection details are stored in SQLite (connection.data).
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?
Here are the default paths where you can find the data collected by Monyog for the first connection created by Monyog.
In windows systems:
XP or older: C:\Documents and Settings\All Users\Application\Data\Webyog\MONyog\data\0001 Vista and newer: C:\Program\Data\Webyog\MONyog\Data\0001
In Linux systems:
- RPM: /usr/local/MONyog/data/0001 - Tar: In the same directory where MONyog was 'untarred'.
When using the GUI to register a server a folder for each connection is created automatically. Folders are named with a 4-digit numerical name ('0001', '0002' etc.). Any number upto 9999 is valid. At start-up Monyog will check for such and use them. So if you simply need to duplicate a connection you can simply copy the '0002' folder for instance and rename to '0003' or whatever (Monyog must be stopped while doing).
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 like: https://addons.mozilla.org/en-US/firefox/addon/5817 (This is a plugin for the Firefox browser and will work 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.