MySQL issues (UPDATE)

[stevewa]

can you connect to the db server using HeidiSQL, and your username (root?) and password?

[pec771]

can you connect to the db server using HeidiSQL, and your username (root?) and password?

No, I can't. That won't load either.

[pec771]

UPDATE. I have installed the latest RadioDJ and MariaDB 11.5.2 and both SEEM to be working so far. But before I try to restore my old db I remember that I had to fix something in the ini file (MySQL) because I have more than 40,000 songs loaded. Something to do with max-packet-size. Will I need to do something similar in MariaDB? I've looked in the my.ini file and there doesn't seem to be an option to do this, it's only about six lines long. 

EDIT: I did try inserting the "max_packet_size=32M" line into the my.ini file but everything broke! Had to re-install MariaDB and I'm now back to where I was, awaiting expert advice before I make another move.

[plauri]

Try to have a look at this post https://www.radiodj.ro/community/index.php/topic,15608.msg86267.html#msg86267

[pec771]

Thanks, had a look but that's above my pay grade, sadly. Sort of get the gist(ish) but not the method. I haven't actually tried installing the large db yet. I'll try that and see what breaks.

[pec771]

I've amended the my.ini file to look like this. Any good?

[mysqld]
datadir=C:/Program Files/MariaDB 11.5/data
port=3306
max_allowed_packet=64M
innodb_log_file_size=512M
innodb_buffer_pool_size=986M
[client]
port=3306
plugin-dir=C:\Program Files\MariaDB 11.5/lib/plugin

[pec771]

Gone a bit quiet here but here's where we now stand. I can't get ANY version of MySQL (new or old) to work or start the MySQL service. They all crash on installation. The MariaDB (11.52) service starts and seems to work with the latest RadioDJ. I can even fiddle with HEIDI a bit. Now, this would be OK I suppose if I didn't have 40,000 songs to import. The idea of starting from scratch is appalling but do-able I suppose, reluctantly. If I could find a fix where I can install my saved db (from RadioDJ 2.0.0.6) then I would be well happy but every time I go near the my.ini file in MariaDB everything crashes again and I'm back to fresh re-installs. I just have to breathe on the my.ini file and everything goes tits up. It seems to be immensely 'sensitive'.

So, I seem to be at an impasse and therefore I throw myself onto the largesse of wiser heads again. Any constructive advice would be MOST appreciated. Cheers.

[Kiwi]

You may wish to look at these videos and progress from here...

Upgrade 2006 to 2039

and this...

Fixing Rotations

You then upgrade from 2.0.3.9 to 2.0.4.5

Hope this helps...

[pec771]

Am in the process of doing this, following Derek's advice in another post. Fingers crossed, looking ok so far. Thanks.