User Tools

Site Tools


audiologger:database-file-on-local-disk

Audio Logger: Move Database File to Local Disk

The problem

Audio Logger keeps a database of all recordings in the file AudioLogger.db inside the slot output directory. This file is regularly updated when recordings are started or stopped.

Internally we use SQLite to manage this database file, a small library that implements an SQL database that does not require a server but stores all data in a regular file.

SQLite does not work well over a network share. In face, the SQLite developers strongly advice against placing the database file onto a network share, as it will result in degraded performance or even data loss.

Solution: Moving the database file

By default, Audio Logger saves the database file in the same folder as the audio recordings. When you choose a network share for the audio, the database file will be stored on the network share as well, resulting in the problems mentioned above.

The solution is to move the database file for each slot onto the local disk of the computer where Audio Logger is running. You need at least version 1.3.3 of Audio Logger.

Step 1: Locate database file

The file is called AudioLogger.db and can be found in the slot output folder.

Step 2: Close Audio Logger

The following steps will require that Audio Logger is not running.

Step 3: Move database file

Choose a location on the local hard disk (e.g. create a folder C:\AudioLogger - do not use a folde protected by UAC, e.g. C:\Program Files!) and move the AudioLoger.db file there. It's OK to rename it when required.

Step 4: Locate and edit AudioLogger.ini

The configuration file for Audio Logger is usually found at C:\ProgramData\mAirList\Audio Logger\AudioLogger.ini. Open it in a text editor.

Step 5: Edit slot configuration

You will see a section [Slot<Number>] for each recording slot, e.g. [Slot0] for the first slot (numbers are 0-based). Inside that section, look for a line like this:

DatabaseFile=

And type the full path and name of the database file after you moved it:

DatabaseFile=C:\AudioLogger\AudioLogger.db

Repeat for each slot. Don't forget to save.

Step 6: Restart Audio Logger

You can now restart Audio Logger, and it will use the database file in its new location.

audiologger/database-file-on-local-disk.txt · Last modified: 2019/07/09 16:18 (external edit)