Retrieve user watched status data from corrupt library

[gold1 3]

Hi,

I had to reinstall emby after HD failure. I have a backup of library.db, but I wasn't able to load the file, so Emby rebuilt the DB. Is there a way to extract watched status and import it into the new DB?

 

Thanks.

[Happy2Play 9783]

Your only option would be possibly export userdatas table, and import into new database.  This assumes something in that table is not corrupt.

Looks like this options was removed from the KB, as there can be issues with database columns as they have been added and removed over the years so there is a chance columns will not align in old vs new.

 

 

[Happy2Play 9783]

Restore User Data
 
Your user data is stored in our old library.db file, and we'll need to run some sql queries to import this into the new library.db in the new Emby Server installation. You'll need a Sqlite database editor such as DB Browser for Sqlite.
 
You'll need to open the old library.db file, then attach the new library.db file. You can then migrate the data using:


REPLACE INTO NewDB.userdata SELECT * FROM userdata

https://emby.media/community/index.php?/topic/67775-how-to-safely-and-efficiently-upgrade-to-v4x-stable/&do=findComment&comment=688781

 

Possible workaround on table mismatch.

https://emby.media/community/index.php?/topic/68980-thank-you-thank-you-so-much-for-v4-well-done/&do=findComment&comment=690548