Migrate database

Hello,

Have to migrate my database to a new server. I did it a few years ago too but that was very confusing, although I did use Roons manual. So I’m very cautious.
The manual starts with a warning:

What do they mean with 2 storage locations active at the same time?

On my new server, I have 2 + 1 storage locations. The card with the Roon installation, the card with all my music, and the mobile drive with the copied database. When the new server is turned on the first 2 locations are active at the same time. Or do they mean something else?

Thanks for support, Bert.

I assume you are using this guide.

During the migration process, both new and old Roon server will be online at some point, and these may use the same storage locations, e.g., NAS, or internal storage. The type of storage determines how you proceed, and this is what the warning is about.

So, if you have internal storage, you’ll need to move this–the first section–whereas for network attached storage you may skip to the second section.

So simply put: if I move the database to the new server, I have to shut down the old server.

In my case, there is probably no shared storage location. Both servers have their own, but identical, music libraries, and the new server needs to receive the database from the old server.
So, I think the second part of the warning does not apply here.

No, this isn’t necessary. Preparation depends on what you are migrating from, and how the storage is attached.

The only storage you move is locally attatched media files, i.e., your music. Do not move the database.

If you decribe your current Roon Server setup and what it’s moving to, it will help the community to guise you.

However, if you want Roon to support you during the migration, please open a Support request as follows.

To equip the Roon Technical Support team to assist you directly, please follow this link to provide the details of your case to Technical Support: Technical Support Request

Respond to the prompts there to ensure that you’ve performed basic troubleshooting and to ensure Technical Support has the full details necessary to expedite Technical Support’s investigation into the case.

Your responses will create a ticket on Roon’s support tracking system and auto-generate a Community thread in the appropriate section.

Because this Community thread will be in a public forum, please do not include any personal information, such as your email address, postal address or telephone number in your submission.

Thank you.

Hello,

Thanks for the support. Of the 3 options above, I am choosing the first one for now.

Here is the setup:

The older server is a SonicTransporter i7 from early 2019. Roon Server and HQPlayerd 4 are installed on it, with my music library on an SSD drive.

The new server is a PC with Debian installed. Furthermore, just like on the older server, Roon Server and HQPlayerd 5 are installed there, with my music library on an SSD drive. The music library on the new server is copied from and synchronized with the music library on the older server.

The intention is for the new server to replace the older one and I will only use the new server. To do this, Database-1 must be migrated from the older server to the newer server so that Roon on the newer server displays the same content as Roon on the older server.

I have already been using the newer server for a few days, so it is probably already building a Database-2. Does this need to be removed first, and where can it be found, before I migrate Database-1, or will Database-2 be overwritten by Database-1?

Once this is clear to me, I can proceed with the migration.
Thanks in advance for the support, Bert.

Backup the database on the older server onto a usb key. Turn off the older server. Restore backup onto new server. Edit any storage changes.

Roons backups overwrite on restore.

All you need to do is skip to step 2 in the guide, backup your current server, and move to step 3. Omce this is done, amend the storage locations as @Rugby says.

Today I will migrate the new database to the ‘new’ server. The new server is not new and there is already a small database but that will be overwritten after install new database, I hope.
The manual only tells about compleet new server and a first contact with Roon.
Now I have to find this database in Settings> Backups> Find backups - browse>…no database

The first folder is not the backup of the new database. This folder is empty and ment for future backups.
But as my musicfolder is visible for Roon I installed the backup in this folder and so I could migrate the database to my new server.

It’’s the last one.

In Storage I had to ad this musicfolder to watch and after 10 minutes I was ready.
And an ever returning problem is the splitting from albums. I had to merge a lot. You can’t have it all.

Don’t do this. The backup must be outside the Library music folder. Otherwise, the new server will attempt to index the backup, and this may cause all sorts of problems.

The best approach is to either share the original location on your network, or copy the backup to a portable USB drive, and use this with the new server.

1 Like

Done, thanks!

2 Likes