RadioDJ database validation

RadioDJ Table Validator

Validate your RadioDJ database structure and identify missing tables, missing columns, incorrect data types and other schema differences.

Database schema validation

Enter your RadioDJ database details

Connect to your RadioDJ database and compare its table and column structure with the expected RadioDJ schema.

Read-only validation

Checking RadioDJ tables...

IP address or hostname RadioDJ database server

Port number Normally 3306

Database name RadioDJ database

Database username SELECT access required

Database password Password for the database user

The validator reads database metadata only. It does not create, remove or alter any RadioDJ tables or columns.

Generated repair SQL should be reviewed carefully and tested on a recent backup before being applied to a live RadioDJ database.

Missing tables can result from an incomplete RadioDJ installation, failed upgrade or damaged database import.

RadioDJ may fail to start or certain features may stop working when a required table is absent.

Compare reported missing tables with the schema expected by your installed RadioDJ version.

A table can exist but still contain missing, renamed or incorrectly configured columns.

Incorrect data types may cause values to be truncated or prevent RadioDJ from saving data.

Differences in nullability or default values can also cause update and insert errors.

RadioDJ database structures can change between releases.

A database restored from an older installation may not match the currently installed application.

Always confirm that the validator is comparing against the correct RadioDJ release before applying suggested changes.

Review every generated statement before running it against your database.

CREATE and ALTER statements can change structures permanently and may affect existing records.

Run repair statements individually where possible and revalidate the database after each change.

Create a full SQL backup before changing any RadioDJ table structure.

Stop RadioDJ while making structural database repairs.

Validate again after an upgrade or database restore.

Test repairs on a copied database before applying them to the live station.