How do I repair a database when I'm using an Nvidia Shield as the Plex server?

[raine247]

Server Version#: Don’t know
Player Version#: Don’t know

Apparently from one guy here it seems that I have a corrupt database. The help guides Plex offers don’t cover the shield so I’m left scratching my head. Can anyone offer a guide?

[tom80H]

You could take a look at some of the existing threads on that very question

NVIDIA Shield - how to repair database?

That article is the only thing with instructions. There are other posts here in the forum discussing them, but I don’t have a reference to anything specific handy. To obtain the database from the Shield, you will need to move the Plex appdata to a user accessible location. There is an option form the Plex client to do this for the server. Moving server data storage location on NVIDIA SHIELD | Plex Support Once that is done, you can then access that location from your Mac using Accessing SHI…

[raine247]

So what am I doing now? I have to move a file to my Mac and then do what? I agree with that guy. They need a more user friendly way to do this.

update: I moved the file to my Mac and ran through commands from the repair database article and I got this error on the last command, “Error: near line 118769: no such collation sequence: icu_root”

When I googled that it pulled up some stuff about linux

[raine247]

So for anyone googling and stumbling on this I just said screw the repairing and moved a backup DB file into the main database location. I force stopped my the Plex server on the shield and copied the backup into the folder where the OG database is stored. I deleted that database and renamed the backup by getting rid of the date that’s tagged on to it. I also deleted the shm and wal files.