Using sdb-admin dump command in K8s Deployment

Help
1

Hello.

Is there any way to use sdb-admin dump for a K8s Deployment of SingleStore. If not, please tell me how I can dump DDL commands of SingleStore pipelines, User CREATE and GRANT commands (I looked into mysqldump but cannot find what I want).

Thank you very much in advance.

2

Consider using

3

The sdb-report collect-kube will have the DDLs for all your pipelines in the directory informationSchemaPipelines and the tables in the schema directory.

The directory informationSchemaUserPrivileges has privileges also in the .txt or .tsv format, we can write a sample script or modify it as per our requirement and run it accordingly.

If you have a support agreement with us please raise a support ticket so that we can provide you the custom script on the same.