Server Version#: 1.21.2.3943
Player Version#:N/A
I got an alert that my db was corrupted. Decided to try and go through the steps in Repair a Corrupt Database | Plex Support. When i get to the part when i need to enter the following command, “sqlite3 com.plexapp.plugins.library.db < dump.sql” I get the following error:
At line:1 char:42
- .\sqlite3 com.plexapp.plugins.library.db < dump.sql
-
~
The ‘<’ operator is reserved for future use.
+ CategoryInfo : ParserError: (
, ParentContainsErrorRecordException
+ FullyQualifiedErrorId : RedirectionNotSupported
I’m guessing it’s not liking my “<” but it had no issue with “>”. I made sure i had the updated sqlite3, and still get the error. I tried to go through these steps below, and still cant figure this out.
Can anyone help my dumbass out?:
Importing data from SQL files
After having used the .dump command inside the sqlite3 prompt to export your SQLite database as an SQL file, you can restore the state of the database by feeding the SQL file back into sqlite3 using the .read command.
Before you can use the .read command, you need to enter the sqlite3 prompt and point it to your SQLite database file:
sqlite3 ./restore.db
Now you can import the data from your SQL files as follows:
.read ./backup.sql
.exit
