How To Uninstall MySQL From Windows

How to Uninstall/Clean MySQL from Windows completely?

1) Run Command Prompt (Type cmd into the search menu in Windows 8/10) and run it as Administrator and execute the following commands to stop and remove MySQL service.

Read the full article

Last updated on: 25th October 2019
at 10:15 AM Europe/London

Why Does RadioDJ Rely On A MySQL Database?

Saw this post on a forum on a post about RadioDJ free radio automation software.

“The biggest fail with RadioDJ to me is the reliance upon a MySQL database”

RadioDJ database setup new

The fact RadioDJ relies on a database for some of it’s functions is actually one of it’s PLUS points.

Read the full article

Last updated on: 8th February 2020
at 09:40 AM Europe/London

Configuring The Windows Firewall

Configuring your firewall

If you’re just running RadioDJ with no webpage linked to the RadioDJ database, then you probably don’t want to add any exceptions to your firewall.

If you’re using a request system and need this extra functionality, you’ll first of all need to make sure your web host has the right ports open. Without this, there’s no point proceeding any further on this article. Check the database utility > Database installation tab. You’ll see the IP address of your server in the MySQL Server box. If there’s a colon followed by more numbers at the end, this is your port number. If there’s no colon, you’re probably using the default port 3306.

You’ll also need to configure port forwarding on your router as well, google the manufacturer’s instruction manual for this bit.

Now for the easy part, configuring the firewall.
Read the full article

Last updated on: 16th February 2019
at 19:32 PM Europe/London

Starting Or Restarting SQL

How to quickly start MySQL

sql-stoppedFrom time to time, for whatever reason, SQL might not start when you boot your computer, and the first thing you know about it is this message when you try and start RadioDJ.

To resolve this you can usually just start the service manually:

Tip: On Windows 8.1/10 right click the start button and select run > services.msc
    Read the full article

Last updated on: 25th October 2019
at 13:21 PM Europe/London

Quickly Re-Enable All Tracks (RadioDJ v2.0.0)

How to re-enable all your tracks

If you store your music on an external hard drive, and accidentally fire up RadioDJ with the drive unplugged, this won’t cause a problem unless you also start playing, and you’ll quickly end up with a lot of disabled tracks.

This can easily be resolved with the database utility and a short SQL script.

One word of caution, this will re-enable all tracks, including any you’ve manually disabled.
  1. Open HeidiSQL log into your database and paste the following query into the query tab and click on the blue (play button at the top) to execute the query
  2. Read the full article

Last updated on: 26th July 2019
at 13:54 PM Europe/London

Sam Broadcaster Bad SQL!

SAM Broadcaster Bad SQL!

We keep seeing posts on the Spacial Audio Facebook pages and forums from people saying that their queue list table within MySQL has crashed and is corrupted.

This is usually the MySQL error that people get.

“MySQLi prepare error: Table ‘samdb_mysql.queuelist’ doesn’t exist”

This has been a major issue within SAM Broadcaster & its SQL tables ever since they wrote the database for SAM Broadcaster v2.x.x

Read the full article

Last updated on: 24th April 2020
at 11:33 AM Europe/London

  Translate