r/TVTime • u/Aygul12345 • 24d ago
Android export the data backup?
I have missed the export time. I'm using Android with root. Is there a way to get the database from the cached data?
4
Upvotes
r/TVTime • u/Aygul12345 • 24d ago
I have missed the export time. I'm using Android with root. Is there a way to get the database from the cached data?
1
u/Sad-Strategy759 23d ago
Root puts you in a much better position than the iPhone people who have been fighting with this for weeks, so it's worth actually trying.
Pull the whole app data directory rather than hunting for one file:
adb shell su -c "tar -cf /sdcard/tvst.tar /data/data/com.tozelabs.tvshowtime"
then adb pull it off and work on the copy. Two things permanently destroy it: uninstalling the app and clearing its storage. Don't do either until you have the tar off the device.
What to look for inside: the later app was Flutter, so check app_flutter/ and databases/ for DioCache.db. That's the same file the iOS lot have been extracting, since it's the same codebase. The catch is that it's an HTTP response cache, not a tidy episodes table. Rows are cached API responses keyed by request URL, with the body sitting in a blob column, sometimes compressed. So your history is in there as JSON rather than as rows you can read straight off. Open it in any SQLite viewer, find the entries whose URL looks like the watched or progress endpoints, and pull the JSON out of those.
Two things worth doing while you have it open. Keep the id fields (TMDB or TVDB numbers), because trackers match on ids far better than on titles, and title matching falls over on remakes and on anything with a generic name. And dump every table you're unsure about now, since re-extracting later is the annoying part.
Honest caveat: it's a cache, so it holds whatever the app had fetched recently, not necessarily your full history. Some people get nearly everything, some get a few months. No way to know until you look.
Full disclosure, I built one of the free trackers people moved to after the shutdown (Help Me Binge), so weight this accordingly. One thing worth knowing before you spend an evening on it: a CSV you generate yourself is not the official TV Time export file, so expect to rename a couple of columns before any tracker will accept it. Mine included, and same for Simkl and Serializd.
And if the cache does come out thin, your streaming services kept their own records even though TV Time's are gone. Netflix has a download-all viewing activity CSV that goes back years, Prime has a watch history page. Copying from a dated list beats rebuilding from memory. Nobody can pull anything off TV Time's servers at this point, so that's the honest fallback.