sebastian13 · July 28, 2023 20:42 · sagaban · May 20, 2021
diff --git a/readme.md b/readme.md
diff --git a/docker-mysql-dump.sh b/docker-mysql-dump.sh
 #!/bin/bash

 # Change to the script's directory & create directory
 cd $(dirname "$(readlink -f "$0")")
 mkdir -p ./dbdumps

 # Start mysql service
 docker-compose --log-level ERROR up -d mysql

 # Wait
 i=20
 while (( i >= 1 )); do
        sleep 1
        echo -ne
        echo -ne "Wait for DB to initialize. Creating Dump in $(( i-- )) seconds ...  "'\r'
 done

 # Load database name + root password
 source .env

 # Delete old Backups
 find ./dbdumps/* -atime +7 -exec rm {} \;

 docker-compose exec -T mysql /usr/bin/mysqldump -u root \
      --password=$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE \
      | gzip --rsyncable > ./dbdumps/`date +\%Y\%m\%d`-$MYSQL_DATABASE.sql.gz
diff --git a/docker-mysql-restore.sh b/docker-mysql-restore.sh
 #!/bin/bash

 # Start mysql service
 docker-compose --log-level ERROR up -d mysql

 # Load database name + root password
 source .env

 # Find latest dumps
 latest1=$(ls -1t ./dbdumps/*.sql.gz | head -1)
 latest2=$(ls -1t ./dbdumps/*.sql.gz | head -n2 | tail -n1)
 latest3=$(ls -1t ./dbdumps/*.sql.gz | head -n3 | tail -n1)

 # Select dump
 echo "Which dump should be used for restoring?"
 select result in $latest1 $latest2 $latest3
 do
    [ $result ] && break
 done

 # Wait
 i=15
 while (( i >= 1 )); do
        sleep 1
        echo -ne
        echo -ne "Wait for DB to initialize. Starting Restore of $result in $(( i-- )) seconds ...  "'\r'
 done

 # Restore
 gunzip --keep --stdout $result | docker-compose exec -T mysql \
 	/usr/bin/mysql -u root --password=${MYSQL_ROOT_PASSWORD} ${MYSQL_DATABASE}
diff --git a/docker-zabbix-mysql-dump.sh b/docker-zabbix-mysql-dump.sh
 #!/bin/bash

 # Change to the script's directory & create directory
 cd $(dirname "$(readlink -f "$0")")
 mkdir -p ./dbdumps

 # Start mysql service
 docker-compose --log-level ERROR up -d mysql

 # Wait
 i=20
 while (( i >= 1 )); do
        sleep 1
        echo -ne
        echo -ne "Wait for DB to initialize. Creating Dump in $(( i-- )) seconds ...  "'\r'
 done

 # Load database name + root password
 source .env

 # Delete old Backups
 find ./dbdumps/* -atime +7 -exec rm {} \;

 docker-compose exec -T mysql /usr/bin/mysqldump -u root \
      --password=$MYSQL_ROOT_PASSWORD \
      --ignore-table=zabbix.acknowledges \
      --ignore-table=zabbix.alerts \
      --ignore-table=zabbix.auditlog \
      --ignore-table=zabbix.auditlog_details \
      --ignore-table=zabbix.escalations \
      --ignore-table=zabbix.events \
      --ignore-table=zabbix.history \
      --ignore-table=zabbix.history_log \
      --ignore-table=zabbix.history_str \
      --ignore-table=zabbix.history_str_sync \
      --ignore-table=zabbix.history_sync \
      --ignore-table=zabbix.history_text \
      --ignore-table=zabbix.history_uint \
      --ignore-table=zabbix.history_uint_sync \
      --ignore-table=zabbix.trends \
      --ignore-table=zabbix.trends_uint \
      $MYSQL_DATABASE \
      | gzip --rsyncable > ./dbdumps/`date +\%Y\%m\%d`-$MYSQL_DATABASE.sql.gz
	#!/bin/bash

	# Change to the script's directory & create directory
	cd $(dirname "$(readlink -f "$0")")
	mkdir -p ./dbdumps

	# Start mysql service
	docker-compose --log-level ERROR up -d mysql

	# Wait
	i=20
	while (( i >= 1 )); do
	sleep 1
	echo -ne
	echo -ne "Wait for DB to initialize. Creating Dump in $(( i-- )) seconds ... "'\r'
	done

	# Load database name + root password
	source .env

	# Delete old Backups
	find ./dbdumps/* -atime +7 -exec rm {} \;

	docker-compose exec -T mysql /usr/bin/mysqldump -u root \
	--password=$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE \
	\| gzip --rsyncable > ./dbdumps/`date +\%Y\%m\%d`-$MYSQL_DATABASE.sql.gz
No results found