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.
Code Block |
---|
|
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.
Code Block |
---|
|
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); |
Scroll pdf ignore |
---|
Newtabfooter |
---|
alias | IDERA |
---|
url | http://www.idera.com |
---|
| | Newtabfooter |
---|
alias | Products |
---|
url | https://www.idera.com/productssolutions/sqlserver |
---|
| | Newtabfooter |
---|
alias | Purchase |
---|
url | https://www.idera.com/buynow/onlinestore |
---|
| | Newtabfooter |
---|
alias | Support |
---|
url | https://idera.secure.force.com/ |
---|
| | Newtabfooter |
---|
alias | Community |
---|
url | http://community.idera.com |
---|
| | Newtabfooter |
---|
alias | Resources |
---|
url | http://www.idera.com/resourcecentral |
---|
| | Newtabfooter |
---|
alias | About Us |
---|
url | http://www.idera.com/about/aboutus |
---|
| | Newtabfooter |
---|
alias | Legal |
---|
url | https://www.idera.com/legal/termsofuse |
---|
|
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal
|