MYSQL setup (first time)

General discussions V2
9k2hn
Novice Class
Posts: 7
Joined: 03 Aug 2014, 09:33

MYSQL setup (first time)

Post by 9k2hn » 18 Apr 2020, 07:18

I'm exploring LOG4OM and because I do have a bit large log (over 400k qso's) I think I need to try MYSQL, but to be honest, I do not have any idea where to start, is there a step by step instruction how to do it?

User avatar
G4POP
Log4OM Alpha Team
Posts: 7245
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: MYSQL setup (first time)

Post by G4POP » 18 Apr 2020, 07:27

Check YouTube for tutorials and I think there is a MySQL WiKi site
73 Terry G4POP

9k2hn
Novice Class
Posts: 7
Joined: 03 Aug 2014, 09:33

Re: MYSQL setup (first time)

Post by 9k2hn » 18 Apr 2020, 11:48

I thought someone can guide me for a step by step way to do it, I know google always there.

n4qs
New user
Posts: 2
Joined: 07 Dec 2015, 21:56

Re: MYSQL setup (first time)

Post by n4qs » 24 Apr 2020, 16:28

Hi Hamad, I would also like to install MYSQL since I have over 182,000 QSOs. Did you figure out how to do it? The setup is asking for a MYSQL address? But I do not know what to enter. Hope all is well. I wish Log4OM2 would provide step by step instructions. 73, Dave, N4QS

User avatar
SP2L
Novice Class
Posts: 24
Joined: 29 Aug 2019, 13:33
Location: Gdynia, Poland
Contact:

Re: MYSQL setup (first time)

Post by SP2L » 04 May 2020, 16:52

Greetings Hamad et al.


I had already my own learning curve,
therefore decided to share my experience.

Uploaded to dropbox.com:
- MySQL-8.0.20-Log4OM2.pdf
- 28 pictures
describing step by step MySQL install routine
and import into it ADIF file with a lot of QSO's.

Here is link to files:

https://www.dropbox.com/sh/wfsehypeg1jy ... UxWta?dl=0


Hope that helps.

Best regards.
Tom - SP2L
Best regards.
Tom - SP2L
https://www.sp2l.ampr.org

vk7yum
Advanced Class
Posts: 34
Joined: 06 Oct 2014, 08:40

Re: MYSQL setup (first time)

Post by vk7yum » 17 May 2020, 01:27

Hi Tom et All
I had already my own learning curve,
therefore decided to share my experience.

Uploaded to dropbox.com:
- MySQL-8.0.20-Log4OM2.pdf
- 28 pictures
describing step by step MySQL install routine
and import into it ADIF file with a lot of QSO's.

Here is link to files:

https://www.dropbox.com/sh/wfsehypeg1jy ... UxWta?dl=0
Works like a treat!

One thing I would add, if you are planning on using JTAlert, on your image MySQL-10 select Legacy method and set JTAlert to
JTAlert-01.png
JTAlert-01.png (7.55 KiB) Viewed 789 times
:D Thanks Tom!

Cheers
David
VK7YUM

User avatar
G4POP
Log4OM Alpha Team
Posts: 7245
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: MYSQL setup (first time)

Post by G4POP » 17 May 2020, 08:15

SP2L wrote:
04 May 2020, 16:52
Greetings Hamad et al.


I had already my own learning curve,
therefore decided to share my experience.

Uploaded to dropbox.com:
- MySQL-8.0.20-Log4OM2.pdf
- 28 pictures
describing step by step MySQL install routine
and import into it ADIF file with a lot of QSO's.

Here is link to files:

https://www.dropbox.com/sh/wfsehypeg1jy ... UxWta?dl=0


Hope that helps.

Best regards.
Tom - SP2L
Tom,
Can I include your guide with the Log4OM User guide downloads?

I would compile all text and images into one pdf file to avoid users accessing your download area too much.

Let me know please
73 Terry G4POP

User avatar
SP2L
Novice Class
Posts: 24
Joined: 29 Aug 2019, 13:33
Location: Gdynia, Poland
Contact:

Re: MYSQL setup (first time)

Post by SP2L » 17 May 2020, 22:10

Terry,

Yes, please proceed - my pleasure.
Best regards.
Tom - SP2L
https://www.sp2l.ampr.org

User avatar
G4POP
Log4OM Alpha Team
Posts: 7245
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: MYSQL setup (first time)

Post by G4POP » 17 May 2020, 22:17

SP2L wrote:
17 May 2020, 22:10
Terry,

Yes, please proceed - my pleasure.
Thank you Tom
73 Terry G4POP

nn3rp
Novice Class
Posts: 17
Joined: 05 May 2020, 00:08

Re: MYSQL setup (first time)

Post by nn3rp » 18 May 2020, 03:06

This MySQL instructions are to the "letter." I've just did mine.

Thanks for providing valuable improvement.

73
Rafael / NN3RP

Post Reply