5,838
edits
MX on Linux: Difference between revisions
m
→Populating your database tables on your Pi
| Line 634: | Line 634: | ||
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. | 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. | ||
The MX release distribution includes another executable. Type <tt>cd CumulusMX && | The MX release distribution includes another executable. Type <tt>cd CumulusMX && sudo mono ExportMySQL.exe monthly</tt> to run the executable. The first parameter is "monthly" even if the table has a different name. | ||
#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 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. | #*if the table already exists, then the executable will use it. | ||
| Line 642: | Line 642: | ||
#*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. | #*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. | ||
Similar instructions apply for the end of day table, although as there is only one daily summary log file, there is no optional second parameter, just type <tt>cd CumulusMX && | Similar instructions apply for the end of day table, although as there is only one daily summary log file, there is no optional second parameter, just type <tt>cd CumulusMX && sudo mono ExportMySQL.exe dayfile</tt>. | ||
There is no way to use this executable for insert of past rows into the real-time table. | There is no way to use this executable for insert of past rows into the real-time table. | ||