I want to learn how to use sql queries through Plex’s sqlite. To do this, I figured I would check the integrity of my database first.
I thought there might be errors because I haven’t seen Plex actually backing up the database in a long time…indeed there were errors including an error that the database image is corrupted. Even though I don’t really experience any issues while using Plex, I figured I would try to fix the errors anyway…
- Automatic fixing of the db did nothing
- Manual → seems to work → no errors when reading in the sql file and the integrity check returns ok
Except the issue is that it’s only ok because there is nothing in the database. Screenshot below of what I see…
- No backups of the database besides my own backup
- 0kb after reading back in the sql dump file
Commands used which do not error when executing are below. Anyone know why this may be happening?
"Plex SQLite" "/mnt/user/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" ".output dump.sql" ".dump"
"Plex SQLite" "/mnt/user/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" ".read dump.sql"
