Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.0.1 (build 4023) - 16 May 2024

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Exportomysql

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
BrunswickWeather
Posts: 77
Joined: Fri 11 Mar 2011 2:04 am
Weather Station: Ecowitt GW1103
Operating System: windows 11 Pro/Raspberry pi 4
Location: Brunswick Australia

Exportomysql

Post by BrunswickWeather »

Does the version included in the in 3220 release the latest version as I seem to have problems. Version 1.6.1.0


'
Microsoft Windows [Version 10.0.22621.963]
(c) Microsoft Corporation. All rights reserved.

C:\Users\ianni>cd \cumulusmx

C:\CumulusMX>exporttomysql dayfile
Parameter: dayfile
Error encountered opening MySQL connection
Could not load file or assembly 'System.Diagnostics.DiagnosticSource, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

C:\CumulusMX>'
User avatar
mcrossley
Posts: 12905
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exportomysql

Post by mcrossley »

I'll update it today to use the newer MySQL library. I missed that dependency.
User avatar
mcrossley
Posts: 12905
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exportomysql

Post by mcrossley »

Version 1.7.0 is now available
iandrews
Posts: 139
Joined: Sun 03 Jan 2010 10:57 am
Weather Station: Davis Pro2
Operating System: Windows 2012R2
Location: London

Re: Exportomysql

Post by iandrews »

Has anything changed with the latest release 3.24.0 - build 323

As I get the below error.

c:\CumulusMX>ExportToMySQL monthly
Parameter: monthly
Error encountered opening MySQL connection
Could not load file or assembly 'System.Diagnostics.DiagnosticSource, Version=7.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

I am on Windows server 2022, with MySQL 8. Cumulus MX connects (and updates) databases fine.
User avatar
mcrossley
Posts: 12905
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exportomysql

Post by mcrossley »

Doh! I forgot to recompile it against the new SQLite3.dll used in v3.24.0. I'll fix it later today.
iandrews
Posts: 139
Joined: Sun 03 Jan 2010 10:57 am
Weather Station: Davis Pro2
Operating System: Windows 2012R2
Location: London

Re: Exportomysql

Post by iandrews »

No rush, I am building a new system and was just going to try (experiment) with it for when I move data over from the current system.
iandrews
Posts: 139
Joined: Sun 03 Jan 2010 10:57 am
Weather Station: Davis Pro2
Operating System: Windows 2012R2
Location: London

Re: Exportomysql

Post by iandrews »

mcrossley wrote: Fri 10 Mar 2023 2:11 pm Doh! I forgot to recompile it against the new SQLite3.dll used in v3.24.0. I'll fix it later today.
Can confirm that Exportomysql now works ok with 3.24.1 (build 3234).

Also, other issues that I saw with 3231 such as select a chart not displaying extra sensors and editing strings.ini not saving are also now working. :clap:
User avatar
mcrossley
Posts: 12905
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exportomysql

Post by mcrossley »

:thumbsup:
Post Reply