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.
Firstly we’ll look at the RadioDJ database backup utility.
Open database setup from the setup folder and select the “auto backup” tab and set it to backup your database at a time when it’s convenient for you.
Set a location for the backups. It’s best if you backup your database to a USB pen drive or other external media.
You can never have too many backups!
Next we will move onto the other part of the maintenance with HeidiSQL
HeidiSQL should have already been installed if you installed MariaDB.
Log into your database using HeidiSQL with the same credentials you used when setting the RadioDJ database up.
Next highlight the RadioDJ database from the list of databases on the left hand side.
Then click on “Tools” from the top menu and select maintenance.
You should see this window.
From here you can repair or optimize the database, you select which option you want from the drop-down menu.
You can select the tick boxes “quick or extended” but we don’t tend to use those we just run optimize or repair whenever we need to do anything to the database.
You can also optimize the RadioDJ database from the utilities menu in RadioDJ or have an event do it automatically for you.
However you should only ever need to repair the database after a power cut or PC crash. Other than that your database just needs light housework/backing up.
It’s not difficult to run maintenance on an SQL database.
We hope you find this tutorial helpful.