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?


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.