Migrating project data to a new server?

General
1

Is there an established way to migrate project data over to a new servers database? Our current Ayon server is very out of date (1.5.2+202410141409). We have a lot of custom code in our codebase so simply updating to the latest repos is not an option. Because of this I plan on building a fresh server based on the latest Ayon codebase, then merge our changes into that. This is to avoid any disruptions to our running projects.

I’m not too concerned with the Ayon settings as those can be easily recreated. But I am not sure how to handle our project data. I’m open to any suggestions.

Thanks!

2

As far as I know, there are two ways to achieve this.

  1. Dump the whole database as mentioned in Backup AYON database/settings
  2. Migrate project by project via
    • in your current ayon-docker, dump the project data
      make dump projectname=YourProjectName
    • copy storage/server/projects/YourProjectName to the new docker location.
    • in the new ayon-docker
      make restore projectname=YourProjectName dump.YourProjectName.sql

I’m following the second approach in my AYON Dev Wrokbench here

Note, this also backup the task assignees which may raise an error/warning if the assigned users don’t exist on the new instance.

3

Thanks! I’ll give this a try tomorrow.