2018-07-05, 01:17
I understand from what I read and past conversations regarding the intentions of keeping tMM simple and to the point. So please hear me knowing I want to keep with that intent. I understand that the database is not a typical database in format, you cannot just open it in an SQL editor. I use both tMM and Trakt to store and organize my data. I have been using https://darekkay.com/blog/trakt-tv-backup/ as a means of backing up Trakt data and obtaining the data for further looking and corrections. Trakt is not open, and users do not really have access to their data.
Without a solid database to use, I prefer to keep a master database of sorts local, so should something happen to Trakt nothing is lost for me. Previously, I used Kodi for this. The database, although having its issues, was fully manageable and changes could be done within Kodi or within a standard SQL query tool. For a while, this was nice. I have since dropped Kodi for many reasons, none of which are relevant, and have replaced Kodi with a combination of tMM and VLC. My only real issue is a lack of a database, well, one that can be managed and queried.
So I am looking for ways I might be able to access the data, independent of tMM. I looked into the export tools, but was unable to locate anything where I can obtain a 'data dump'. Understanding there is not a typical database structure, there is still structured data. Is there some way I might be able to dump ALL data in its stored structure, where I might be able to import elsewhere to query? At this time, I am looking for export from tMM only... although an import after changes would be nice I understand the issues that could pose though, and I understand the tMM database was not designed with that type of interaction in mind.
Without a solid database to use, I prefer to keep a master database of sorts local, so should something happen to Trakt nothing is lost for me. Previously, I used Kodi for this. The database, although having its issues, was fully manageable and changes could be done within Kodi or within a standard SQL query tool. For a while, this was nice. I have since dropped Kodi for many reasons, none of which are relevant, and have replaced Kodi with a combination of tMM and VLC. My only real issue is a lack of a database, well, one that can be managed and queried.
So I am looking for ways I might be able to access the data, independent of tMM. I looked into the export tools, but was unable to locate anything where I can obtain a 'data dump'. Understanding there is not a typical database structure, there is still structured data. Is there some way I might be able to dump ALL data in its stored structure, where I might be able to import elsewhere to query? At this time, I am looking for export from tMM only... although an import after changes would be nice I understand the issues that could pose though, and I understand the tMM database was not designed with that type of interaction in mind.