Deleting Live TV Data and Channels from the Jellyfin Database

One of the problems with Jellyfin is that older Live TV data is not deleted from the database even if all the guide sources and the TV tuner are removed from the configuration. The only way to ensure that the old metadata is gone, is by first stopping jellyfin:

systemctl stop jellyfin

and then editing the database manually to remove all Live TV data:

echo "DELETE FROM TypedBaseItems WHERE TYPE LIKE 'MediaBrowser.Controller.LiveTv.%;'" | sqlite3 /var/lib/jellyfin/data/library.db

After that, jellyfin can be restarted again, and all the Live TV channels and metadata should be gone:

systemctl start jellyfin