How to backup pipelines


#1

I performed a mysqldump --all-databases and upon restore noticed that none of the 9 pipelines we had defined were carried over. Are they stored in a different way and how can I back them up in order to import to other clusters?


#2

Hello daemon_of_chaos! thank you for trying out pipelines.

mysqldump is a MySQL tool and thus it is not aware of MemSQL PIPELINE feature.

However, you can still backup and restore databases together with pipelines using BACKUP and RESTORE commands. https://docs.memsql.com/operational-manual/v6.7/backing-up-and-restoring-data/