MySQL utils

makefile

backup:
	docker stop mysql1 || true
	docker run --rm --volumes-from mysql1 -v $(BACK_DIR):/backup ubuntu tar cvf /backup/sql_volume.tar /var/lib/mysql
	docker start mysql1
restore:
	docker stop mysql1
	docker run --rm --volumes-from mysql1 -v $(BACK_DIR):/backup ubuntu bash -c "rm -rf /var/lib/mysql/* && cd / && tar xvf /backup/sql_volume.tar"
	docker start mysql1
load:
	docker exec -i mysql1 mysql -uroot $(DATABASE_NAME) < mysqldump
start:
	docker run -d --restart=always --name=mysql1 -p=3306:3306 -e=MYSQL_ALLOW_EMPTY_PASSWORD=yes mysql:5.7.21 --max-allowed-packet=1073741820 --wait-timeout=2147483 --interactive-timeout=2147483 --default-time-zone='+00:00'