Preferences and Connection Settings
Preferences and global settings
In addition to the data stored on a per-server basis; Monyog has a database storing global user preferences (preferences.config database) and also a very tiny text file (MONyog.ini), that only has what minimal information is required for Monyog to start.
There is a [preferences] table in connection.data which is used for storing the default processlist query.
CREATE TABLE IF NOT EXISTS [preferences] ( [name] VARCHAR(50) DEFAULT '' NOT NULL PRIMARY KEY UNIQUE, [value] TEXT DEFAULT '');
The 'server_names' table is used for storing all the connection details.
CREATE TABLE [server_names] (id INTEGER DEFAULT 0 NOT NULL PRIMARY KEY UNIQUE, key VARCHAR(255) DEFAULT '' NOT NULL, value VARCHAR(255) DEFAULT '' NOT NULL);