MX on Linux: Difference between revisions

You might have started using MX before you set up your database. There is a option in that part of the admin interface to create database tables (as required) for each of the 3 updating intervals. For example, the default name for the table updated at the standard interval is "monthly", but you could give it a name of "standard" or whatever you like.

 

#if the table name is defined in the admin interface, but the actual table does not exist, this executable will create a table with that name and the columns for the schema that applies at the release version.

#*if the table already exists, then the executable will use it.

#*the SQL syntax used is "insert ignore", so if the row for that log file line already exists in the table, it will skip onto next line of log file.

 

 

There is no way to use this executable for insert of past rows into the real-time table.