Website: mysql Backup&Restore procedure

[xaoo]

Hey,

we are trying to restore kubeflow mysql db. Is a mysql dump enogh to backup?

we are dealing with the current error after restore:
Error: failed to generate Pipeline graph.
An error occurred
Cannot read property 'spec' of undefine

[issue-label-bot[bot]]

Issue Label Bot is not confident enough to auto-label this issue. See dashboard for more details.

[sarahmaddox]

/assign @IronPan

[xaoo]

I found that if I add a pipeline, backup the mysql DB, delete the pipeline then restore, that pipeline will return the erro above.

all the other pipelines, which were not deleted, just backed and restored, are ok.

[xaoo]

Hey guys, any suggestions?
I need to know what that delete button does when a pipeline is deleted.
Because it's sure deletes more than something in mysql.

In this way I can prepare some consistent backups.

TY
//George

[sarahmaddox]

/cc @paveldournov Do you have any suggestions for this problem? Many thanks, Sarah

[xaoo]

Hey Sarah, thank you, that would be really helpful to find out the missing dependency when we delete a pipeline

[IronPan]

just to double check did you follow up this instruction or some other ways
https://www.kubeflow.org/docs/pipelines/upgrade/

[xaoo]

Hi, so I found the missing dependency in the minio pod, path: /data/mlpipeline/pipelines.
This is a bit tricky, but now I can do a consistent backup.

Thank you