How do I upgrade MySQL database?

Need help? - Post here and we will find a solution for you.
Locked
w5rkn
Novice Class
Posts: 4
Joined: 21 Aug 2014, 15:35

How do I upgrade MySQL database?

Post by w5rkn »

I have been running Log4OM 1.6 and I just downloaded and installed Log4OM 1.18.0 and received the notice that my MySQL database needs upgrading. I found a link to the script (http://www.pisto.it/LogOm/mysql1171.zip) but how do I run the script?

MySQL reports that all components are up-to-date.

Ron W5RKN
User avatar
IW3HMH
Site Admin
Posts: 2988
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: How do I upgrade MySQL database?

Post by IW3HMH »

Hi Ron, script must be executed from MySQL db manager.
If you're not skilled with DB management under MySQL my suggestion is to get the latest backup automatically made by Log4OM and then re-create a new database with new release, re-importing your ADIF
Daniele Pistollato - IW3HMH
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: How do I upgrade MySQL database?

Post by G4POP »

w5rkn wrote:I have been running Log4OM 1.6 and I just downloaded and installed Log4OM 1.18.0 and received the notice that my MySQL database needs upgrading. I found a link to the script (http://www.pisto.it/LogOm/mysql1171.zip) but how do I run the script?

MySQL reports that all components are up-to-date.

Ron W5RKN
MySQL is a little bit more complex to run from Log4OM itself, because you must use ROOT permissions, these are not saved by Log4OM so you should open mysql management window and run the script with root permissions.
73 Terry G4POP
Locked