Kodi Community Forum

Is there way for me to remove just the movies from the MySQL database and leave TV intact?

I have noticed the movie DB seems to have a lot of dodgy or duplicate info tried a few ways to clean but to no avail. I don't really want to dump the whole DB as I don't want to lose TV Watched status etc, I literally just want to remove all the movie entries.

If you want to cleanup database - that's for you: https://www.erol.name/how-to-additionall...d-entries/

Thanks but already gone over that... I have dupe entries.. missing entries... entries that have the wrong info etc so am just looking for a way to bin it all off.

Videos > Files
Select the source(s) that has / have films on.
Choose 'set content' in the context menu, set content to 'none'.
You'll be asked if you want to clean the library - obviously yes.
As far as what you see goes that's it. There'll probably be rubbish left on your database referring to deleted stuff, but you won't see it. There are various tools / add-ons around for cleaning up the db if needed.

If you added a source with both movies and tv-shows in the same source, then you have identified why it scraped badly.

Found this... http://forum.kodi.tv/showthread.php?tid=272112 did exactly what I needed.. movies gone... TV kept... perfect!