I've had issues restoring from backups with Plex. But for me to get it to work I had to delete multiple files and then only restore the 2 .db files and start plex again.
Of course make backups of these files first.
Shutdown plex
Delete:
com.plexapp.plugins.library.blobs.db
com.plexapp.plugins.library.blobs.db-shm
com.plexapp.plugins.library.blobs.db-wal
com.plexapp.plugins.library.db
com.plexapp.plugins.library.db-shm
com.plexapp.plugins.library.db-wal
Restore ONLY (copy from backup):
com.plexapp.plugins.library.blobs.db
com.plexapp.plugins.library.db
Start plex again. See if that works for you. If the other DB files in that directory are not corrupted you might be able to restore one of the dated ones that are in this folder. Also make sure the date stamps you restore are the same dates.
PLEX: Unable to set up server: sqlite3_statement_backend::prepare: database disk image is malformed
in General Support
Posted
Thanks, I resolve the problem too.