Update fusio system

[Leonardo Carvalho]

Hi,

I need to update fusio to the latest version which is currently fusio api version 6.1.1.0. But I don't want to lose the data in my mysql 5.7 database. Is there any way to perform a system migration that updates the tables and other necessary configurations of the database, which is in a separate docker container and so I can update fusio to version 4.0 (psx 7.5.3.0)?

[Christoph Kappestein]

Hi,

this requires some work but it is possible, we have written a documentation of this process at:

https://github.com/apioo/fusio/blob/master/UPGRADE.md

Before starting the upgrade always create a backup of your current database since the migration may fail.

best regards

Christoph

[Leonardo Carvalho]

Hi,

Thank you for your help!

But when trying to run the 'php bin/fusio migration:migrate' command to update the database schema, it threw an error due to the lack of the 'metadata' column in the 'fusio_routes' table. I am using version 2.* of the fusio docker repository and the api version is fusio 6.1.1.0. Is there a way to update my database with a script despite its schema being older than version 3.3 of fusio which adds the 'metadata' column?

[Christoph Kappestein]

Hi,

ok, since your database has not the metadata columns you have indeed an older version, in this case I would recommend to first move your database to version v3.3.2 and from there you should be able to install the current 4.x version.

best regards

Christoph