RadioDJ - Free Radio Automation Software Forum

RadioDJ v1.7+ => v1.7+ - Support Forum => Topic started by: DJdeWit on August 02, 2014, 06:57:33 PM

Title: Setting up RadioDJ with old MySQL server....is it possible ?
Post by: DJdeWit on August 02, 2014, 06:57:33 PM
Hi there :)

I'm trying to set up RadioDJ 1.7.2 , but my problem is my old MySQL server (4.1.22) I'm afraid.
Unfortuantly I hardly know anything about MySQL and do have some other programs using the old server.
So a fresh install won't be possible I'm afraid.
I most likely need to update the MySQL server, but have no clue how, as I never done something like that before.
Or is there a way to have 2 MySQL servers on 1 (Windows) machine ?
Or is it possible to run RadioDJ 1.7.2 with the old MySQL server somehow ?

Title: Re: Setting up RadioDJ with old MySQL server....is it possible ?
Post by: AndyDeGroo on August 02, 2014, 07:24:53 PM
Yes, it is possible to run two MySQL instances on one PC, but I'd suggest upgrading, because MySQL 4.1.22 is insanely old. That is unless you have legacy applications that can't handle newer MySQL protocols or new password hashing algorithm.
If you still want to run another instance alongside old one, you'll have to change listening port number. It should be available during setup.

MySQL upgrading is a multi-step process on Windows and can't be accomplished without some downtime.
Here's how to do it, step by step:
1. Export all databases from old MySQL using mysqldump or your favourite MySQL management tool
2. Stop and remove MySQL service, if it was installed
3. Install new version of MySQL
4. Set up users and permissions (can be done during installation)
5. Import data dumps from old database

There are other ways to do upgrades, but I find this less painful.

Another option would be to install MariaDB which offers data and settings migration from MySQL, but it might not be able to migrate data from really old MySQL versions. If so, you should proceed same as with MySQL upgrade.