Storage

Previous  Top  Next

All of MyCon's local storage requirements, ex. reports, scripts, queries, configuration files, etc, is done to files located in the MyCon subdirectory located just beneath the MyLook installation directory. MyCon itself, it's help and configuration files as well as MyRun (if installed) are all located in the MyLook installation directory.

This means MyCon is completely transferable to another computer and backing up your data and work is extremely easy to accomplish. No registry entries whatsoever are made which MyCon needs, relies on or uses to function at full capacity.

All files get's saved automatically with a specific filename format:
"Mysql host"."Mysql database"."Type"."Name"."Custom"."Extension"

·	MySQL host      Hostname/IP of your MySQL server/connection

·	MySQL database   Database name of the specific file, if this file is applicable to a top level, like Queries, then this value becomes "Root"

·	Type         The type of folder, for example, Table, Query, Report, etc

·	Name         The name of the folder or table or query

·	Custom      This part is usually not added, but in certain situations an unique name is needed in which case this part gets added.

Some typical examples:
localhost.mydatabase.Table.newtable.ini         - Config file for the newtable found in database mydatabase on localhost
localhost.mydatabase.Query.newquery.sql      - Custom SQL script file for newquery found in database mydatabase on localhost
localhost.mydatabase.Query.newtable.Backup.sql   - Backup script for a new table
localhost.Root.Script.newscript.sql         - Script found in the localhost(or whatever you named your connection)/Scripts folder, i.e. not database specific
localhost.mydatabase.Report.newreport.rtm      - Report template file for a mydatabase report

Using this method, it is very easy for you to find all report files, or all a specific database's files, or all Backup/Dump scripts, or all sql files and maybe back them up to somewhere else. Or even move your whole configured MyCon to a new machine, all you have to do is copy one directory's files.

If you want MyCon to operate in a multi-user environment
MyCon allows you to split "that which may be common for a multiple users" from "that which may be changed by certain users", thus in short a split between configuration and data/reports. This is accomplished by MyCon by initially reading the [INSTALLDIR]\"mycon.ini" file for a section called "[Paths]". If a "DataDir=C:\My Documents" for example, is found in this section, MyCon will load all it's config files from this installation directory while the "DataDir" will be used for storage of scripts, reports, db and table config files. Thus the DataDir overrides the default [INSTALLDIR]\MyCon behaviour for documentation/data storage, which means that all the config files can in essence be marked "read-only".