fathonir

#!/usr/bin/bash #Centos
#!/bin/bash     #Ubuntu

BACKUP_FILE=namadb_$(date +'%Y%m%d').sql
DB_USER=db_user
DB_NAME=db_name
SERVER_TARGET=login@ip:path

mysqldump -u $DB_USER $DB_NAME > $BACKUP_FILE && scp $BACKUP_FILE $SERVER_TARGET && rm -f $BACKUP_FILE