[Terselesaikan] Cara Backup Semua Database Mysql di Linux | Bash Script

1. Buat file backupdb.sh

mkdir /backup/database_mysql
nano /backup/database_mysql/backupdb.sh

2. Masukkan script berikut:

#!/bin/bash
#
#
backupdir="/backup/database_mysql"
#
mkdir $backupdir/$(date +%d-%m-%Y)
#
for DB in $(mysql -e 'show databases' -s --skip-column-names); do mysqldump $DB > "$backupdir/$(date +%d-%m-%Y)/$DB.sql"; done

- simpan dan exit ctrl+x, y, enter

3. Atur permissionnya

chmod 777 /backup/database_mysql/backupdb.sh

4. Silahkan coba jalankan dengan perintah:

sh /backup/database_mysql/backupdb.sh