Where is the database after the upgrade?

Maiahr

During the week my pastor has upgraded OpenLP to the latest version. Today (Sunday) I started it but there wasn't a single song! I couldn't find the database with the songs after the upgrade. Where should I look for it? Ideally, if at all possible... if anyone could connect remotely to our church PC and help me find the database, would be great....

PaulRowell

Maiahr on the Tools menu there is an item to open the data folder. I'm not sure why your songs database wasn't upgraded as part of the upgrade process.

There is a possibility that you may have moved the data folder to a non standard location?

When upgrading your pastor would have had to answer a question about whether to keep a backup of the existing databases.

Maiahr

PaulRowell Thanks... On the Tools menu WHERE should I look for it? What is the database file extension?

And no, unfortunately the pastor hasn't done a backup of the database...

PaulRowell

On the tools menu there is "Open data folder...":
[upl-image-preview uuid=c6201a00-1924-411c-9f9d-1bd9ff167e0d url=https://discuss.openlp.org/assets/files/2025-03-24/1742816179-692553-image.png alt={TEXT?}]

The default data folder is %APPDATA%\openlp\data

The songs database should be in the songs folder and is called songs.sqlite

revncele

The backup will be in the parent of the data folder i.e. %APPDATA%\openlp\