Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- echo "Backup."
- cp com.plexapp.plugins.library.db backup-com.plexapp.plugins.library.db
- echo "Runnig plexinc recommended checks."
- sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'"
- sqlite3 com.plexapp.plugins.library.db "DELETE from schema_migrations where version='20180501000000'"
- sqlite3 com.plexapp.plugins.library.db "PRAGMA integrity_check"
- echo "Deleting duplicates.."
- #sqlite3 com.plexapp.plugins.library.db "delete from media_streams where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1);"
- #sqlite3 com.plexapp.plugins.library.db "delete from media_items where id in (select media_item_id from media_parts group by file HAVING count() > 1);"
- #sqlite3 com.plexapp.plugins.library.db "delete from media_item_settings where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1);"
- #sqlite3 com.plexapp.plugins.library.db "delete from media_parts where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1);"
- sqlite3 com.plexapp.plugins.library.db "BEGIN; delete from media_streams where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1); delete from media_items where id in (select media_item_id from media_parts group by file HAVING count() > 1); delete from media_item_settings where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1); delete from media_parts where media_item_id in (select media_item_id from media_parts group by file HAVING count() > 1); commit;"
- echo "Dumping."
- sqlite3 com.plexapp.plugins.library.db .dump > tmp.sql
- echo "Restoring."
- rm com.plexapp.plugins.library.db
- sqlite3 com.plexapp.plugins.library.db < tmp.sql && rm tmp.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement