Database Editor (1 Viewer)

[boozelclark]

I'm looking to move all my media from an external hard drive to an internal one. The problem is that i dont want to have to download all the movie info etc. Does any one know of a good database editor with a find replace feature, so i can just edit the path of the database entries. ie change the I: to c:
thanks

 

[charli181]

you could download any SQLite gui search in google (plenty for free). Most don't seem to have a search/replace feature so I would suggest exporting to csv and the searching replacing via excel/notepad. Then import back into the database. You might find it best to make a copy of the original database first.
I did exactly what you did sometime ago and I think I had to delete all entries in the database before I imported the modified records otherwise you may get double entries.

 

[boozelclark]

Thanks a lot. how would you export to .csv?

 

[ronilse]

Hi,
In MediaPortal root folder you have a docs folder which contains a "SQLite Database Browser".

Regards
Roy