Kodi: Reset/delete database

[^rooker]

[PROBLEM]
I haven't found any way of simply purging an outdated Kodi database.
Cleaning the database takes foreeeeeeveeeer - and when removing missing sources, it asks for every single folder whether to keep or delete it.

Setup is: Kodi v16 (Jarvis) on LibreElec v7.0.2 on a Raspberry Pi 1 (model B).

[SOLUTION]
So I chose to delete the Kodi database file(s).

1) SSH to Kodi/Libreelec

2) Go to the folder: ~/.kodi/userdata/Database
(/storage/.kodi/userdata/Database)

Here's an example what you may find there:

Code: Select all

-rw-r--r--    1 root     root         28672 Oct 16 22:54 ADSP0.db
-rw-r--r--    1 root     root        921600 Mar  2 09:23 Addons20.db
drwxr-xr-x    2 root     root          1024 Oct 16 22:53 CDDB
-rw-r--r--    1 root     root         28672 Oct 16 22:54 Epg11.db
-rw-r--r--    1 root     root        188416 Oct 16 22:54 MyMusic56.db
-rw-r--r--    1 root     root      15355904 Mar  2 18:22 MyVideos99.db
-rw-r--r--    1 root     root         32768 Oct 16 22:54 TV29.db
-rw-r--r--    1 root     root       2715648 Mar  2 18:15 Textures13.db
-rw-r--r--    1 root     root         20480 Dec 16 14:53 ViewModes6.db

3) Delete the database file:
Then delete the database file (.db) for whatever library you want to purge:

• MyMusic*.db (Music)
• MyVideos*.db (Video / TV-Shows / Movies)

4) Reboot Kodi.