Page 1 of 1

Bbdd CumulusMX v3 and MySQL

Posted: Thu 18 Jul 2024 6:10 am
by CarlosLSev
Hello, I have a question, I have CumulusMX v3 working, they gave me a script that works in CumulusMX but I need to activate MySQL. The way I have it now I have it under control. For backup copies, just copy the "data","Reports" folder and the cumulus.ini file. Or copy the entire folder. In version v4 things already change somewhat but it hasn't migrated yet. My question is if I activate the MySQL option. The database is still on my Raspberry or it is now on the web server where I have the mysql database. What would the copy process be like once the mysql option is activated? Or is everything simply the same and cumulus separately sends those 3 mysql tables to the server Let's see if someone can clarify for me Thank you Modify message Report

Re: Bbdd CumulusMX v3 and MySQL

Posted: Thu 18 Jul 2024 7:16 am
by water01
There are no changes to the MySQL tables between Version 3 and Version 4 and the MySQL tables are held on your web server which is assumed to run the requisite MySQL set up.

The move to V4 involves converting all the data files held by CumulusMX to a new format with a Universal Date format, the MySQL files are not affected, so there is no reason not to implement the MySQL feature in version 3.

Re: Bbdd CumulusMX v3 and MySQL

Posted: Thu 18 Jul 2024 2:59 pm
by CarlosLSev
hello, but for backups just copy the data from the cumulusmx folder on the raspberry pi

Re: Bbdd CumulusMX v3 and MySQL

Posted: Sun 21 Jul 2024 10:55 am
by CarlosLSev
Hello, can someone clarify my doubt if after activating the mysql options in cumulusmx v3 or v4 to be able to use a script that only works in mysql on my web server, the database of.cumulusmx is still on my raspberry pi in data, the folder inside CumulusMX

Re: Bbdd CumulusMX v3 and MySQL

Posted: Sun 21 Jul 2024 12:18 pm
by mcrossley
It is. Nothing changes in CMX, the MySQL data is extra and only ever written to by MX.

Re: Bbdd CumulusMX v3 and MySQL

Posted: Sun 21 Jul 2024 1:39 pm
by CarlosLSev
Thanks Mark, I had that question. By the way, you haven't published the windrose script for cumulus, which I believe you are the creator of, right? https://weather.wilmslowastro.com/windrose.php I already have it but I was curious