Cumulus Support

How do I use the script to update the SQL tables?
I do have said tables but do not do much at all with MySQL....

Guy

grwkak wrote: ↑Wed 06 May 2020 12:24 am I do have said tables but do not do much at all with MySQL

If you used MX to create the tables, those tables will have right columns for the rest of my answer. If you created tables another way, you do need SQL understanding, to update them.

Each of the updating queries in MX (for tables it creates), are controlled by an enable tick box, it is as simple as that.

You may also have to do one other thing depending on your hosting service. Most of them will not allow an undeclared inward connection to a MySQL server (for obvious reasons), so you will have to add your IP address to the Remote MySQL which should be available in your cPanel or its equivalent on your host.

Remember this is the IP address that your router appears on the Internet not your internal network IP address. You can find that out by using this site https://www.whatismyip.com/.

If you do not have a static IP from your ISP then you may have a problem if you reboot your router or have a power failure as you may find that the IP address will change. Most (but not all) ISPs allow you to buy for a small fee (mine was £5) a static IP address and that is the best option.

Its been a while but I believe I did use MX to create! So what I am hearing is that once I update to the new version of MX it will take care of the new fields?

Guy

Yes that is correct. If you have existing files a script was provided to update the tables to include the new fields, but obviously the data will not be available in those fields up until the date CumulsMX 3076 is implemented.

There is a SQL script available here viewtopic.php?p=142177#p142177 to update the monthly table.

If you have not run CumulusMX before and have no historic data in MySQL tables this does not apply to you, you just create the tablles and enable the functions.

I guess my real question is how I run that script. Sorry about this - just being cautious before doing this. I do have mySQL workbench installed and can connect to the database. This is a newer PC and I had it on my previous PC - just reinstalled.

Guy

If the MySQL WorkBench is able to connect to the server then you can run the SQL on that. I personally used the Cpanel interface which my hosting service provides and within that is phpMyAdmin that allowed allowed me to connect to the database and its tables as well as allowing me to run SQL on the various tables.

But you have now prompted me into using MySQL workbench which I used on Windows 7 but did not add to my Windows 10 pro computer!! Completely slipped my mind!! But phpMyAdmin did a good job

Incorrect answer removed.

Well OK but in my opinion he was asking how to extend the existing tables to include the addition fields in those tables and for that you use the SQL script zipped at the bottom of the release notice.

Correct - my focus was on the tables. I was able to use the script, modified for the names of the tables,in mySQL Workbench - they seem updated!

Now to check it runs properly!

Thanks for everyones help and suggestions.

Guy