Preferences and Connection Settings

Preferences and global settings

In addition to the data stored on a per-server basis; SQL DM for MySQL 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 SQL DM for MySQL to start.

connection.data

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);