Backup all databases

Help
1

Dear All,

Could you help me with a script that can take backup of all databases dynamically and send out email with the status after job completion.

I am using Singlestore 7.5 version and have 53 databases to backup. trying to check if this is possible and looking out for your support.

Regards,
Kranthi

2

You could write a script to do that that queries information_shema.distributed_databases
then generates the backup commands for each DB and runs those commands. The backup command does not work from within stored procedures so you would have to do it with an external script or program.

1 Like