Hi,
If you want to remove all songs, playlists, categories and subcategories, there are two ways; You can start from scratch by recreating RadioDJ database using Database Setup or you can delete contents of songs, category, subcategory and playlists_list tables.
Either way, it is fast and easy to do in Database Setup program in "...\RadioDJ\Setup\" folder.
First, exit RadioDJ. Then start Database Setup and make a database backup by clicking on "BACKUP DATABASE" button. You may have to set correct path in Auto Backup tab for backup to work, if you haven't used it before.
To start from scratch with default database entries:
1. In Database Setup, click "INSTALL DATABASE"
Warning! All existing data will be lost. Make a backup before doing this!
2. Notification will pop up asking if you are sure you want to install database. Click "OK" to install database.
3. Start RadioDJ, edit categories and import tracks
To delete only the contents of tables:
Imortant: RadioDJ will complain if all categories have been deleted, so this approach may be better suited for advanced users who are able to recreate categories outside RadioDJ using HeidiSQL or other tools.
1. In Database Setup, switch to Run SQL Query tab;
2. Run following queries:
Warning! All category, subcategory, song and playlist data will be lost. Make a backup before doing this!
truncate `songs`;
truncate `category`;
truncate `subcategory`;
truncate `playlists`;
truncate `playlists_list`;
I highly recommend setting up automatic backups in Database Setup. You can always go back to previous backup if something goes wrong.