EURCHF: null null GBPAUD: null null AUDJPY: null null NZDUSD: null null USDCHF: null null USDJPY: null null NZDJPY: null null EURGBP: null null EURCAD: null null EURAUD: null null GBPJPY: null null GBPUSD: null null EURUSD: null null AUDUSD: null null CADJPY: null null

Export logs of MT4

Export logs of MT4

Allows uploading log file of MT4 server operation to MySQL database (configuration providing compatibility with other databases is available)
Features:
* Significant reduction of storage size required for log records. Due to optimized structure of stored data records require up to 10 times less of hard disk space.
* Availability of log file analysis automation which allows early detection of malfunctions, accidents, attacks on server and etc.
* Additional copy of system logs allows to check records integrity in case of suspisions of main file modification
* Optimization of MT4 disk space. In case of usage fast but small sized disks like SSD's or high speed SAS HDD's storing log files of journal can become an issue. Utility allows to archive most of outdated log files to reduce disk space usage and request data via database server.

Structure of created tables:
CREATE TABLE `mt4logs`.`20140102` (
`code` int(1) unsigned DEFAULT NULL,
`time` time DEFAULT NULL,
`second` int(3) DEFAULT NULL,
`ip` varchar(32) DEFAULT NULL,
`line` text
) ENGINE=ARCHIVE DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;


Brief description of operation:
After startup utility connects to MySQL server and requests list of existing tables then compares it with list of files stored in log folder (can be specified in settings). All files which are not found in databse excluding current one (for current day) are exported to database.
For each file table with same name is created.

Settings:
[MySQL]
server=127.0.0.1 // server IP address
port=3306 // server port
login=Login // user login
pass=pass // password
DB=mt4logs // Database for storing logs 
Tbl_Pref=logs_ // prefix set in front of records, i.e. real_ demo_

[Conf]
Dir=C:\logs // path to folder with log files.
  • 0
  • 1 658

Add comment

    • bowtiesmilelaughingblushsmileyrelaxedsmirk
      heart_eyeskissing_heartkissing_closed_eyesflushedrelievedsatisfiedgrin
      winkstuck_out_tongue_winking_eyestuck_out_tongue_closed_eyesgrinningkissingstuck_out_tonguesleeping
      worriedfrowninganguishedopen_mouthgrimacingconfusedhushed
      expressionlessunamusedsweat_smilesweatdisappointed_relievedwearypensive
      disappointedconfoundedfearfulcold_sweatperseverecrysob
      joyastonishedscreamtired_faceangryragetriumph
      sleepyyummasksunglassesdizzy_faceimpsmiling_imp
      neutral_faceno_mouthinnocent
reload, if the code cannot be seen