Contoh Script Backup Semua Database MySQL dalam File Terpisah
Berikut adalah contoh script Bash yang bisa kamu gunakan untuk membackup semua database MySQL dalam file-file yang terpisah.
#!/bin/bash ################################################ # MySQL User USER='root' # MySQL Password PASSWORD='password' # Backup Directory - NO TAILING SLASH! OUTPUT="." ##### And TIMESTAMP=`date +%Y%m%d_%H%M%S`; mkdir $OUTPUT/$TIMESTAMP; cd $OUTPUT/$TIMESTAMP; echo "Starting MySQL Backup"; echo `date`; 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/dbbackup-$TIMESTAMP-$db.sql gzip $OUTPUT/dbbackup-$TIMESTAMP-$db.sql fi done echo "Finished MySQL Backup"; echo `date`;