Restoring portions of a database

Server Version#: latest
Player Version#: latest

I feel stupid, but I accidentally renamed a folder in a library containing a lot of media. Almost immediately the Plex Media Scanner started running. I have renamed the directory back to the original, but the affected library now has a lot of missing items. I also noted that some media is being identified as if it is new to the library. I have shutdown PMS and created a sql dump of the database, dump513.

So I grabbed a backup from 5/11 and have created a sql dump of it, dump511. What I would like to do is identify which tables from 513 to replace in 511 to just save the stats pieces up to today.
This would repair what I did without losing the stats? No content has been added to PMS recently, so I dont need to worry about saving ‘new content’.

Thoughts?

The table you want is metadata_item_settings.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.