(2020-04-20, 15:36)Knocks Wrote: and I don't have a SQL backup
Are you using the local SQLite database file, or you using a MySQL database server..?
Making a copy of a single MyVideos116d.db is so much easier. Install a decent File Manager on your Shield (e.g. X-Plore File Manager), and make a copy of the database file before you mess up more.
(2020-04-20, 15:36)Knocks Wrote: how would option 1 help if you're still supposed to run "library cleanup," which removes deleted movies anyway?
If you can change the hostname of your 'server', it should convince the Clean Library action, there is no such server anymore with the old name, and thus remove the old entries.
However, you say you want to keep the watched/resume statuses. Those would all be on the old movie database entries...
(2020-04-20, 15:36)Knocks Wrote: I delete most of my watched movies but want to keep then in my library for recognizing actors, directors etc.
Ehh.. No comprendre mucho of that. You manually delete the file from your server?
The next Cleanup should wipe that database.
Normally actors, directors should be removed as well whenever a movie is removed. I guess you are still using a Kodi 'feature', that it doesn't remove all the linked info.
So, either you can rename your file server's hostname, of you'll need to do some SQL entangling.
Unplucking a SQL database is not as easy as doing a few file operations.
Also, there is no way to tell what will happen with watch statuses when you do a Library Export, since old and new files are already in there together. The new ones will probably will overwrite the old ones.
Or, you can fully start from scratch with a new/clean database...