Going back from shared DB to local DB possible?

knuti · February 2, 2019 at 9:33 PM

Hi,

I'd like to thin out my home IT a bit and therefore I'd like to go from my shared sql database back to a local one.

Is there a way to import the data with watched state, info, covers... without havin to scrape everything again???

Any hint would be highly appreciated!

**Klojum** · February 2, 2019 at 9:53 PM Official Post

Quote from knuti

without havin to scrape everything again???

There is no Kodi MySQL-2-SQLite conversion tool that I know of. Sorry,

Enable watched states and resume points via the advancedsettings.xml file.

Do a Video Library Export, preferably via separate files.

Remove the MySQL connection, restart Kodi/LibreELEC.

Re-enable your video source(s) for the local db

Scrape your video collection.

Because of the previously exported info, rescraping will go much faster.

knuti · February 3, 2019 at 11:16 AM

Klojum, thank you!

Not the preferred answer, but after my google search fail kind of what i expected...

I will give it a try this way...

**vpeter** · February 3, 2019 at 11:26 AM

Exporting library with MySQL connection, removing MySQL connection and then importing library would not work?

knuti · February 4, 2019 at 8:10 PM

i need to try this when i find the time, probably next weekend... that would be awesome