Confusion into MusicDatabase, How to clean? (1 Viewer)

TiboTv

Portal Pro
June 22, 2009
244
39
Home Country
Belgium Belgium
Hi,


I've got a lot of old entries which stays into my musicdatabase since i've done a complete rescan of the database.

If I mannually edit the database (by sqlitebrowser), I can find double entries into "tracks table" pointing on the same file. This is probably due to the fact that I've updated a big part of the IDtags to make my music library more complete.

The only work around that I've found until now is to erase all entries into the "tracks table" which are double. I do that with the sql cmd : DELETE FROM tracks WHERE strArtist = "| artistname |" and than make a new complete rescan of the database (by the MP config menu).

This is a long and high-risk work into the database!

Is there any way into MP config to delete all entries into the musicdatase to make sure that the database is totally clean before a new scan?

Thanks for the answers. :D

Tibo
 

Paranoid Delusion

Moderation Manager
  • Premium Supporter
  • June 13, 2005
    13,062
    2,978
    Cheshire
    Home Country
    United Kingdom United Kingdom
    Follow the shortcut for "user files" from your windows start menu, or at top left of MP config, its in the database folder.
     

    TiboTv

    Portal Pro
    June 22, 2009
    244
    39
    Home Country
    Belgium Belgium
    Thank you for the help!

    I wasn't sure that deleting the database could work.
    I suppose that MP could create himself a new database? I'll test it this evening.

    :D
     

    Users who are viewing this thread

    Top Bottom