How to merge two databases?

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.

To merge two databases:

1. Download migration tool

Download for Windows Download for Linux (x64) Download for Linux (ARM)

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.

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.