MySQL issues (UPDATE)

[pec771]

Long story short. RadioDJ stopped working last night for no known reason, unable to connect to or start the MYSQL server. After a while trying things I gave up scratching my head, came on here and saw that people were mainly using MariaDB. So, got rid of MYSQL, installed MariaDB and installed a fresh copy of the latest RadioDJ. Both SEEM to have installed properly and the MariaDB Service is running but I don't know what to do next to get RadioDJ to use MariaDB instead of MySQL. The Database Setup still seems to be linked to MySQL and I can't get past that issue. Do I have to do something obvious that isn't clear to me? How do I get RadioDJ to 'link' to MariaDB is basically what I'm asking (in simple English, I'm not an expert in these things).
I DO have copies and backups of my previous RadioDJ installation including settings and databases if they come into it somehow. Any help would be greatly appreciated.

[plauri]

You said you get rid of MySQL: so if you have uninstalled MySQL, installed MariaDB and loaded your last DB backup into MariaDB it's impossible that it's linked to MySQL. After loading your db backup into MariaDB run from Setup ---> Database Setup ---> Database Utils ---> Repair Database and then Optimize Database. It should work, if don't there is another problem.

[pec771]

You said you get rid of MySQL: so if you have uninstalled MySQL, installed MariaDB and loaded your last DB backup into MariaDB it's impossible that it's linked to MySQL. After loading your db backup into MariaDB run from Setup ---> Database Setup ---> Database Utils ---> Repair Database and then Optimize Database. It should work, if don't there is another problem.

Thanks. I haven't done anything yet. Where do I put the database backup in MariaDB? Basically, what files do I have to put where to make RadioDJ work? Running Database Setup at the moment just leads to error messages implying I need a connection to a server. Both programs are currently untouched and unamended and will remain so until I get relevant advice.

[Music Box]

Hi, I hope this helps you.
1) Save to your desktop backup.
2) Uninstall everything, MariaDb, MySql and RadioDj.
3) Install MariaDb.
4) Install RadioDj.
Before activating RadioDj enter your MariaDb password and the name of your Database.
Copy your database from your desktop to C/RadioDj2045/setup/ Backup folder.
Open the Setup folder, click on Database Setup exe,
click on Validate Details.
Click Restore Database, select your database that you copied to the backup folder, click open, overwrite, ok again.
Restart RadioDj, if you followed the instructions it should work.
Important: Open the Database setup exe, click on Auto Backup,
Correct the path to C:\ RadioDjv2045\Setup\Backup.
Hope this helps.
Hi

[pec771]

Hi, I hope this helps you.
1) Save to your desktop backup.
2) Uninstall everything, MariaDb, MySql and RadioDj.
3) Install MariaDb.
4) Install RadioDj.
Before activating RadioDj enter your MariaDb password and the name of your Database.
Copy your database from your desktop to C/RadioDj2045/setup/ Backup folder.
Open the Setup folder, click on Database Setup exe,
click on Validate Details.
Click Restore Database, select your database that you copied to the backup folder, click open, overwrite, ok again.
Restart RadioDj, if you followed the instructions it should work.
Important: Open the Database setup exe, click on Auto Backup,
Correct the path to C:\ RadioDjv2045\Setup\Backup.
Hope this helps.
Hi

Thanks. Line 5, where do I enter my MariaDB password and the name of the database? Into what? I've included a screenshot of Database Setup. I can't get further than that. Oh, and running services behind it which shows that MariaDB is running but I can't connect to a SERVER. Apologies for my ignorance but databases are new to me. MySQL worked easily when I installed it years ago! Once something 'clicks' I get it but nothing's clicking yet.

[pec771]

Should be a pic here.

[plauri]

Should be a pic here.

You should use the same password and the same name of the database that you used with MySQL.

"where do I enter my MariaDB password and the name of the database? Into what?". In the pic you posted there is written "MySql database", there you should write the name of the db and where there is written "MySQL password" the password, but please follow what Music Box suggested, it's pretty clear.

[pec771]

I wish! I haven't created or 'named' a db yet. What do I put in the 'MySql database' name, MariaDB/mariadb/radiodj or something similar?  I know my password ok. I'm sure it's something simple to solve but I just can't connect to a server. May try going back to MySql and earlier RadioDJs if I get no joy, if they still work that is. Sigh.

Thanks for yours and other peoples' help so far, I appreciate it.

P.S. What's this HEIDI program that seems to have been installed with MariaDB?

[DJGaryBaldy]

Heidi Sql is an Sql editing tool don't worry about it too much

As for naming the database you can call it whatever you want.

INSTALLING MARIADB

[pec771]

Hmm, saying that...I think I may have created the password for HEIDI and maybe NOT for MariaDB. I wonder. Does anyone know the DEFAULT password for Maria? 'changeme' 'admin' perhaps?

[DJGaryBaldy]

Your MariaDB password will the same as the password you log into Heidi SQL with

[plauri]

Nooooo, you should use the same name you used with the previous MySQL db and the same password while you install MariaDB or you will never get your playlist/rotation/song you had before. And you will have to start radiodj from the beginning that is loading songs, jingles, create rotations and events etc.

[pec771]

At the risk of sounding exasperated are we talking at cross purposes? I haven't created any new dbs so what is this 'name' that people keep referring to? I'm talking about the Database Setup Utility. The four entries you have to fill in to connect to the server. Mine are;

My SQL Server:  127.0.0.1    (Nothing to do with me. I assume it's automatic)
My SQL Database:             (Always left it as it was)
My SQL Username: root        (Again, seemingly automatic. Never changed it)
My SQL Password: xxxxxxxxxx  (I know it, not a problem)

It's the second one I think is the issue. I think it used to be 'radiodj' or similar but I've tried variations without success. As I say, I still have a copy of my old RadioDJ program/settings. I was using 2.0.0.6 whereas the version I've now 'installed' is 2.0.4.5. Might I find anything in there that would help? I'm tempted to scrap it all and start again tomorrow. If I do, what do people recommend as the best combination of Database/RadioDJ? Is MariaDB worth persevering with?

Once again, thanks for the help you've all been providing. Sorry it's all been fruitless so far.

[Derek]

The Database Setup still seems to be linked to MySQL and I can't get past that issue.

Just to rule out some possible confusion, the RadioDJ setup utility will always say "MySQL..." in the database name, username, password lines etc. but it's just the title of those fields in the setup utility program.

It doesn't mean it's still linked to an old MySQL installation. If you've installed MariaDB, it won't change the name of the field titles, but you'll be using MariaDB.

As others have said, enter the username and password that you used to set up MariaDB after you installed it and you can call the database whatever you like, but you then have to click on "Install Database" before you can use it for the first time, or to be able to restore one from a backup as it's got to have a database file installed that it can work with to restore to, which basically means overwrite the new empty database with a previously backed up file.

[pec771]

Cheers, that all makes sense. It's the options in the utility that don't work. When I try to 'install' or 'restore' anything the program locks up with a connection error mode. Probably the reason why the original RadioDJ stopped working in the first place. Nothing's worked since. Dunno, could my antivirus/firewall be blocking something? It seems that connecting to a/the server is problematic for some reason, although the MariaDB SERVICE is running ok. Will muddle on, thanks.