Difficulties recovering malformed database

Plex Media Server
1

Server Version#: Latest Stable
Player Version#: Latest Stable

I’ve come up against a malformed (error 11) database. Unfortunately it seems that all of the backups are also malformed.

Using the instructions for a db recovery on this page, I can get through the list and the final instruction to sqlite>> .read db-recover.sqlite seems to complete.

However, I am not seeing the restored database.

Any help?

Thanks

2

There is another way to do this:

"Plex SQLite" com.plexapp.plugins.library.db  .dump >   dumpfile.sql
mv com.plexapp.plugins.library.db com.plexapp.plugins.library.db-damaged
"Plex SQLite" com.plexapp.plugins.library.db < dumpfile.sql

You’ll need to use correct path for Plex Sqlite,
then set ownership and perms afterward

3

Nevermind. Worked it out.

When re-opening sqlite after
“Once the original corrupted database has been moved, start the SQLite shell back up using the same command as before, then run the following command:”

specify the database, i.e.


>  "/usr/lib/plexmediaserver/Plex SQLite" com.plexapp.plugins.library.db
4

OK, thanks. I’ll remember it for next time.

ATM the database recovery as worked. My bad for not specifying the recovery database file name when re-opening sqlite,

Cheers