what tool do I need to repair the database ? You provided me with this link:
https://support.plex.tv/articles/201100678-repair-a-corrupt-database/
I went there and they talking about SQLite tool to repair the corrupted database.
Is there another tools for that ?
Yes, yes… I was under the impression you were just gonna restore from an earlier db.
But now looking at how old your backups are you would be better off repairing.
Let us know how it goes.
Hi
I tried to repair the database, but I keep receiving errors, when I used PRAGMA integrity_check, also I was given another error related to schema refreshing, I don’t what all this stuff means, I spent last night googling for solutions, but nothing helpful.
Let’s start here
- Make sure you quit/exit your Plex Media Server so that it is not running. The following commands are run in the Command Prompt application. When running the commands, be sure to enclose paths in quotes to handle spaces in paths. First, simply switch over to the directory containing the database.
cd "%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases"
I followed the example in the repair post and I’ve got the following errors when I was checking the database integrity:
Yep. Shows the corruption. I would still continue on.
sqlite3 com.plexapp.plugins.library.db .dump > dump.sql
del com.plexapp.plugins.library.db
sqlite3 com.plexapp.plugins.library.db < dump.sql
I completed all the recommended steps, but I’m surprised when I see the plex database has zero (0) bytes and the dump.sql file has 104MB.
Is this command “sqlite3 com.plexapp.plugins.library.db < dump.sql” supposed to restore the data to the database?
How I can get the data back ?
Thank you.
It dumps it as importable sql statements. You can easily see by opening the dump.sql file in your favorite text editor. You will see statements like CREATE TABLE, INSERT INTO, CREATE INDEX, etc…
Though, it does seem it bit small. I believe your db is so corrupt that a restore may not be possible.
Yes, it should. It seems your db is severely corrupted.
Do the following to restore your original back.
del com.plexapp.plugins.library.db
copy com.plexapp.plugins.library.db.original com.plexapp.plugins.library.db
Unfortunately, I do not know of any utility to repair sql db’s.
OK, my database is corrupted, the program SQLite3 can not fix it. I downloaded the SysTools Sqlite Database Recovery software and it was effective. Unfortunately, it’s a demo version, I can not back up the database and it’s expensive.
I decided to start my library from scratch, but I want to keep my account information intact. What are the steps necessary to achieve this?
Thank you.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
