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
 # Change to the script's directory & create directory
 cd $(dirname "$(readlink -f "$0")")
 mkdir -p ./dbdumps

 # Start mysql service of your compose file
 docker-compose up -d mysql

 # 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
 # Start mysql service of your compose file
 docker-compose up -d mysql

 # Load database name + root password
 source .env

 # Find latest dump
 latest=$(ls -1t ./dbdumps/*.sql.gz | head -1)

 # Restore
 gunzip $latest | docker-compose exec -T mysql \
 	/usr/bin/mysql -u root --password=${MYSQL_ROOT_PASSWORD} ${MYSQL_DATABASE}
	# Change to the script's directory & create directory
	cd $(dirname "$(readlink -f "$0")")
	mkdir -p ./dbdumps

	# Start mysql service of your compose file
	docker-compose up -d mysql

	# 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