102. How can I backup the database and create the cron job?

_Backupmysql scripts

#!/usr/bin/env bash

set -x
#set database name
database=kendanic

user=ken
passwd=password
backup_dir="/home/rcms-lap-173/backup/"
TIMESTAMP=$(date +%Y%m%d%H%M%S)
backup_file="$backup_dir/kendanic-$TIMESTAMP.sql

sudo mysqldump --no-tablespaces -u$user -p$passwd $database > $backup_file

cronjob command for every two mins

*/2 * * * * /bin/bash /var/scripts/backup.sh

fourcodes-org / proof-of-concepts

102. How can I backup the database and create the cron job? #133