Automatic Backup & Restore

Hey guys!
We want to automate the database backup process in background, perhaps with crontab

What would you recommend to automate this task correctly? Any useful example?

Cheers

1 Like

You can use a cron job to run a script to do a backup, e.g.:

memsql --batch -Ne"backup database db1 to ‘backup1’" -pPwdString

You’ll have to make the script provide a new backup file name every day.

1 Like