Backup the database in Linux by compressing the generated file

backup_db.sh

# Current datetime
now="$(date +'%Y%m%d-%H%M')"

# DB credentials
db_name=my_db_name
db_host=my_db_hostname
db_user=my_db_user
db_password=my_db_password

### EXAMPLE ###
#db_name=db_teste
#db_host=localhost
#db_user=user
#db_password=123456

# Backup file
sql_file='db_backup_'$now'.sql'

echo 'Backing up the database on the backup folder'

mysqldump -h $db_host -u $db_user -p$db_password -v $db_name | gzip > './backup/'$sql_file'.gz'

# Para voltar o backup
# gunzip < dump.sql.gz | mysql -u USUARIO -pPASSWORD -v