Backup Script PostgreSQL & MariaDB/MySQL

backup-mysql.sh

#!/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

backup-pg.sh

#!/usr/bin/bash

# Harap memastikan ssh-nya sudah ssh-copy-id

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

pg_dump -U $DB_USER -F c -f $BACKUP_FILE $DB_NAME && scp $BACKUP_FILE $SERVER_TARGET && rm -f $BACKUP_FILE