manictime整合两个数据库的数据

作用

老电脑崩溃了,有个1t.db，

新电脑有个3t.db

那么重装系统后就想整合起来用。

整合前文件大小

整合命令

.\mtdb.exe importtimelines -sdbpa ManicTimeCore-1t.db -dbpa ManicTimeCore-3t.db -tt ManicTime/ComputerUsage,ManicTime/Applications,ManicTime/Documents

为了方便理解，整理了下(下面的这个有回车符 ，不要使用)：

.\mtdb.exe importtimelines

-sdbpa ManicTimeCore-1t.db

-dbpa ManicTimeCore-3t.db -tt ManicTime/ComputerUsage,ManicTime/Applications,ManicTime/Documents

整合的log

PS F:\360MOveData\Users\Administrator\Desktop\需要整合的数据\mtdb> .\mtdb.exe importtimelines -sdbpa ManicTimeCore-1t.db -dbpa ManicTimeCore-3t.db -tt ManicTime/ComputerUsage,ManicTime/Applications,ManicTime/Documents
Found timeline match for timeline type 'ManicTime/ComputerUsage': f8d228f0-db1a-41f5-bb0f-cd49ec98fdfd -> f8d228f0-db1a-41f5-bb0f-cd49ec98fdfd
Found timeline match for timeline type 'ManicTime/Applications': f604f025-e36e-4853-8b7d-28e40ec8d353 -> f604f025-e36e-4853-8b7d-28e40ec8d353
Found timeline match for timeline type 'ManicTime/Documents': d9e059bb-f8f8-4107-af81-69a9e7bc7357 -> d9e059bb-f8f8-4107-af81-69a9e7bc7357

Importing timeline 'ManicTime/ComputerUsage': f8d228f0-db1a-41f5-bb0f-cd49ec98fdfd -> f8d228f0-db1a-41f5-bb0f-cd49ec98fdfd
Getting changes for source timeline.
Public change log: {"ChangeLogKey":"tqxldhvy53ca2","ContinuesFrom":null,"CommitedRange":{"From":"1,136815289","To":"165243,1088420022"},"EntityId":22959,"LastGarbageCollectedChangeId":null,"ContentSize":500,"Timestamp":"149048,488854146","UpdatedUtcTime":"2024-10-25T02:44:52.45Z","ChangeLogLockKey":null,"ChangeLogLockedUtcTime":null}
165243 changes found. 22267 activities, 4 groups, 0 folders
Getting changes for target timeline.
Public change log: {"ChangeLogKey":"tqxldhvy53ca2","ContinuesFrom":null,"CommitedRange":{"From":"1,136815289","To":"203504,1561099050"},"EntityId":27101,"LastGarbageCollectedChangeId":null,"ContentSize":500,"Timestamp":"185196,644833025","UpdatedUtcTime":"2024-10-25T06:12:23.12Z","ChangeLogLockKey":null,"ChangeLogLockedUtcTime":null}
203504 changes found. 26239 activities, 4 groups, 0 folders
Importing activities..........
Imported: {"ActivityCount":744,"GroupCount":0,"GroupListCount":0,"FolderCount":0,"HasChanges":true}

Importing timeline 'ManicTime/Applications': f604f025-e36e-4853-8b7d-28e40ec8d353 -> f604f025-e36e-4853-8b7d-28e40ec8d353
Getting changes for source timeline.
Public change log: {"ChangeLogKey":"qwmneciqmg7tg","ContinuesFrom":null,"CommitedRange":{"From":"1,73931181","To":"328109,1008691102"},"EntityId":242558,"LastGarbageCollectedChangeId":null,"ContentSize":500,"Timestamp":"93176,1135188914","UpdatedUtcTime":"2024-10-25T02:44:52.33Z","ChangeLogLockKey":null,"ChangeLogLockedUtcTime":null}
328109 changes found. 234555 activities, 551 groups, 0 folders
Getting changes for target timeline.
Public change log: {"ChangeLogKey":"qwmneciqmg7tg","ContinuesFrom":null,"CommitedRange":{"From":"1,73931181","To":"389596,1674482312"},"EntityId":285681,"LastGarbageCollectedChangeId":null,"ContentSize":500,"Timestamp":"113809,485355108","UpdatedUtcTime":"2024-10-25T06:12:23Z","ChangeLogLockKey":null,"ChangeLogLockedUtcTime":null}
389596 changes found. 275667 activities, 648 groups, 0 folders
Importing activities..........
Imported: {"ActivityCount":4996,"GroupCount":15,"GroupListCount":0,"FolderCount":0,"HasChanges":true}

Importing timeline 'ManicTime/Documents': d9e059bb-f8f8-4107-af81-69a9e7bc7357 -> d9e059bb-f8f8-4107-af81-69a9e7bc7357
Getting changes for source timeline.
Public change log: {"ChangeLogKey":"ixje5igioii5a","ContinuesFrom":null,"CommitedRange":{"From":"1,294111474","To":"9370,1474956114"},"EntityId":7294,"LastGarbageCollectedChangeId":null,"ContentSize":500,"Timestamp":"4215,47436061","UpdatedUtcTime":"2024-10-23T13:32:09.59Z","ChangeLogLockKey":null,"ChangeLogLockedUtcTime":null}
9370 changes found. 6530 activities, 589 groups, 2 folders
Getting changes for target timeline.
Public change log: {"ChangeLogKey":"ixje5igioii5a","ContinuesFrom":null,"CommitedRange":{"From":"1,294111474","To":"10379,1724632066"},"EntityId":8062,"LastGarbageCollectedChangeId":null,"ContentSize":500,"Timestamp":"4802,322427995","UpdatedUtcTime":"2024-10-13T08:03:56Z","ChangeLogLockKey":null,"ChangeLogLockedUtcTime":null}
10379 changes found. 7195 activities, 652 groups, 2 folders
Importing activities..........
Imported: {"ActivityCount":20,"GroupCount":2,"GroupListCount":0,"FolderCount":0,"HasChanges":true}

Import completed.

整合后文件大小