Auto Backup all the databases every 30 days on server

autobck.sh

#!/bin/bash
 
USER="USER_NAME"
PASSWORD="PASSWORD"
OUTPUT="BACKUP_PATH"

#Deletes all the files before dumping again 
rm "$OUTPUT/*gz" > /dev/null 2>&1 

databases=`mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
 
for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        mysqldump --force --opt --user=$USER --password=$PASSWORD --databases $db > $OUTPUT/`date +%Y%m%d`.$db.sql
        gzip $OUTPUT/`date +%Y%m%d`.$db.sql
    fi
done

crontab

crontab -e
0 0 */3 * * /PATH/autobck.sh