You can merge data from two databases, but we recommend this only when data is not from two devices which were recording at the same time.
For example, a good usage of merging would be if you changed machines, installed ManicTime, but later remembered you have data from previous machine. Now you want to keep the newly recorded data and also add data from previous machine.
Merging two databases needs to be done in two steps:
- Merging tags, which can be done with export/import
- Merging tracked data with mtdb tool
1. Merging tags
To merge tags, export tags on one machine and import them on the other:
1.1. Export tags on source machine
On source machine go to Tools -> "Import and export", then export Tags timeline.
1.2. Import tags on target machine
On target machine go to Tools -> "Import and export" and import the exported tags file.
Importing from backup file
If data you want to import is in a backup file, then download portable version, extract it to some folder, run it and restore the backup. Then follow the steps above. Once you imported tags exit portable version and delete the portable folder.
2. Merging tracked data
To merge tracked data (this tool does not merge tags):
2.1. Download migration tool
Download for Windows Download for Linux (x64) Download for Linux (ARM)
2.2. Make sure ManicTime is not running
Right click on ManicTime icon in the tray and exit the app. ManicTime must not be running while merging databases.
2.3. Merge databases
ManicTime on Windows installed with setup
If you are on Windows and ManicTime is installed with normal setup, so that its data is in default location (C:\Users<username>\AppData\Local\Finkit\ManicTime), then you can run the tool with just the path to the database you want to import:
.\mtdb.exe importtimelines -db client -sdbpa C:\temp\db1\ManicTimeCore.db -tt ManicTime/ComputerUsage,ManicTime/Applications,ManicTime/Documents
In this case, data from C:\temp\db1\ManicTimeCore.db will be imported into C:\Users<username>\AppData\Local\Finkit\ManicTime\ManicTimeCore.db
ManicTime portable or non-Windows version
If you have portable version or your database is in another folder, then run the tool by providing path to both source and target database:
.\mtdb.exe importtimelines -sdbpa C:\temp\db1\ManicTimeCore.db -dbpa C:\temp\db2\ManicTimeCore.db -tt ManicTime/ComputerUsage,ManicTime/Applications,ManicTime/Documents
In this case, data from C:\temp\db1\ManicTimeCore.db will be imported to C:\temp\db2\ManicTimeCore.db.