Auto backup DB
Who can help me?
I want to make an automatic backup of my db. But when I type ./backup.sh into my terminal nothing happens. So I don't think the backup is being made?
or do i have something wrong in my code?
ps. I use windows
Code:
#!/bin/bash
DB_USER="root"
DB_PASSWORD=""
DB_NAME="twt"
echo "Database back-up is gemaakt: $BACKUP_FILE"
0 0 * * 0 /bin/bash /mnt/c/Users/mstep/Documents/TWT_ProjectDev/Twt/backup.sh >/dev/null 2>&1
I want to make an automatic backup of my db. But when I type ./backup.sh into my terminal nothing happens. So I don't think the backup is being made?
or do i have something wrong in my code?
ps. I use windows
Code:
#!/bin/bash
Databasegegevens
DB_HOST="localhost"DB_USER="root"
DB_PASSWORD=""
DB_NAME="twt"
Pad naar de back-updirectory
BACKUP_DIR="/mnt/c/Users/mstep/Documents/BACKUP_Twt"Bestandsnaam voor de back-up (voeg de huidige datum toe aan de bestandsnaam)
BACKUP_FILE="$BACKUPDIR/backup$(date +%Y%m%d%H%M%S).sql"Maak de back-up met mysqldump
mysqldump --host=$DB_HOST --user=$DB_USER --password=$DB_PASSWORD $DB_NAME > $BACKUP_FILEecho "Database back-up is gemaakt: $BACKUP_FILE"
0 0 * * 0 /bin/bash /mnt/c/Users/mstep/Documents/TWT_ProjectDev/Twt/backup.sh >/dev/null 2>&1
