DJ Garybaldy - The Only sound you need

Seen more and more users who've recently had issues working RadioDJ alongside Oracle MySQL (8) server. I personally think Oracle MySQL lost their way a LONG time ago. I Wrote A While Back about this very issue it seems MySQL8 still doesn't work properly. A soon as people switched to MariaDB their issues went away (Strange That) Marius carried out out some tests a while back and its quite clear that MySQL 8 takes longer to process queries compared to MariaDB. Query Duration MySQL8: 1.7712764 seconds Query Duration MariaDB: 0.0081946 seconds As you can see the difference is Huge on MySQL8 it takes 2 seconds to run a Query I've been a MariaDB user since 2014 and its RARE I have to do any maintence on my SQL databases. IF You have been having issues with MySQL download and install MariaDB Instead! How to Install MariaDB Please Note: Some versions of MariaDB have issues with RadioDJ due to a Database update

I love HeidiSQL as a database editing tool, It also allows me to do maintenance on my databases should the worst happen. MariaDB should automatically install Heidi SQL alongside the database engine Its taken me a few years to feel confident around editing MySQL databases but now I find it really easy to do. I have two instances of SQL servers on this PC I have Oracle MySQL 5.5.9 on Port 3306 and MariaDB 10.5.8 on Port 3007. MariaDB databases shouldn't require much housework once installed I rarely touch my databases but on the odd occasion I have to give them a quick repair. I can easily log onto to sort it with HeidiSQL and its easy to keep on top of your MySQL Server. I knew next to nothing about how to maintain an SQL server 12 years ago but I learned by reading tutorials on the Internet. HeidiSQL makes my life so much simpler I'm not having to rebuild my databases regularly like I was back

After 7 and a half years with my RadioDJ database I've decided to rebuild my song library from scratch. My SQL database hasn't crashed its just I felt like doing a rebuild. I've spent a lot of time staring at tracks manager over the past couple of days. Knowing the categories my music was previously catalogued under has made life a lot easier. You can setup and create multiple subcategories and genres. Top Tip: Whenever you make a change to any of your songs you need to take a backup this will preserve your changes. This is where RadioDJ excels compared to other expensive radio automation software Other software doesn't come with a way to backup your database data IF you manage to get your database backed up in other radio software you may just find it doesn't backup all your table data. Whereas the RadioDJ database setup tool backs up your entire database and ALL your table data.

So you've successfully installed and configured the RadioDJ database. Now you have it installed its a good idea if once in a while you do some basic maintenance to ensure optimum operation. Its not that difficult to maintain and backup your RadioDJ database. A backup of your SQL database is essential in case the worst should happen to your computer. First: We'll look at the RadioDJ database backup utility. Open database setup from the setup folder select the auto backup tab and set it to backup your database at a set Hour. TIP: Backup your database to a directory or drive of your choice You can never have too many backups The database backup happens in the background Tick the box that says close to the system tray Close to tray and FORGET about it. Fact: Other paid for radio automation doesn't backup the whole database Next we will move onto the other part of the maintenance with HeidiSQL HeidiSQL should have already been installe

A SAM Broadcaster user wanted to move their current MySQL database over to a new machine and appears to be having trouble doing so... That's the problem with SAM Broadcaster Pro while there is a backup feature it only backs up program files/settings and NOT the database. Users trying to backup SAM often run into error messages like this. Although why its trying to store a backup as .csv when it should be .sql puzzles me. You have to use external software or batch files if you want to even attempt to try and backup your MySQL database with SAM Broadcaster Pro After you've managed to take a backup of the SAMBC Database the events table isn't backed up as part of the backup and you will lose your events. RadioDJ comes with a tool that enables you to backup your RadioDJ database every day. ALL the data is backed up as part of the RadioDJ MySQL backup. If you decide to move RadioDJ to a new Computer all you would need to do is res