Radiodj Database Maintenance

So you’ve successfully installed and configured the RadioDJ database.

Click to enlarge

Now you have it installed its a good idea if once in a while you do some basic maintenance to ensure optimum operation.

Read the full article

Last updated on: March 26th, 2017
at 15:11 PM Europe/London

What A Difference 5 Years Makes

It’s now over 5 years since we first discovered & started using RadioDJ radio automation software.

RadioDJ 1.3.7.0

RadioDj 1.6.0

We started looking for another automation solution because SAM Broadcaster just wouldn’t work as it was supposed to.

Read the full article

Last updated on: October 2nd, 2016
at 10:45 AM Europe/London

What Database Issues?

I asked my partner to find out when we actually installed MariaDB on our PC that we run RadioDJ from.

Turns out we’ve had MariaDB installed since June 2014.

Yesterday we upgraded it to the latest version. Which went smoothly after we’d remembered to shut mysqld.exe down as a service.

Click to enlarge

In the last 15 months that we’ve been using MariaDB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden shutdown of the computer.

That was easily fixed using Heidisql to repair the tables.

“We could never say the same about another well known automation program. The database in that would crash when you least expected it and was royal pain to fix again. That’s if you were lucky enough to retrieve your database as that program never had a proper database backup tool.

 
We take a regular daily backups of our database with the RadioDJ database setup tool.

The database in RadioDJ is far more robust and tends not to go wrong unless something major happens on the PC running it.

On the whole MariaDB seems to work like a star.

We’d like to thank the development team at MariaDB for making such a wonderfully stable SQL server program.

What Database Issues? I wouldn’t have a stable reliable music stream without it!

RadioDJ of course has to take some of the credit.

“RadioDJ and MariaDB are the most reliable and stable pieces of software we’ve EVER used and we’ve used lots of other databses”

 
So next time you’re looking to install a database for use with a radio automation program such as RadioDJ

RadioDJ Free radio automation download
Download

@MariaDB is the database program EVERYONE should be using.

Last updated on: October 23rd, 2016
at 13:40 PM Europe/London

Radiodj Database Backup

You can now automatically backup your RadioDJ database at a specified hour of the day with the database setup tool.

Click to enlarge

It’s pretty straight forward to set up.

1) Download RadioDJ
2) Unzip the RadioDJ folder to C:\ outside of the program folder.
3) Open up databasesetup.exe inside the setup folder.
4) Install RadioDJ and install your database as per these Instructions
5) In the second tab set the time and location where you want to backup your database.
6) Minimise to the tray and leave it running.

 
It should automatically backup your database at the hour you set it to backup.

Top Tip: Try making sure you backup your database to an external drive. A small 1GB USB pen drive will do. That way you don’t have to worry about losing your database data in the unlikely event of your database crashing or a power cut.

 

Last updated on: March 26th, 2017
at 15:31 PM Europe/London

Translate ยป