Subhajeet Dey subhajeet2107

Avid Pythonista, FC Barcelona fan and Fifa Gamer, startup enthusiast and open source evangelist

subhajeet2107 / mysql_backup.sh

Created August 5, 2016 11:11

Simple bash script to take mysql backup of database

	#!/bin/bash
	# Simple script to backup MySQL databases

	# Parent backup directory
	backup_parent_dir="/var/dbdumps/mysql"

	# MySQL settings
	mysql_user="root"
	mysql_password=""
	#name of database which you want to backup

subhajeet2107 / compress_dump.sh

Created July 30, 2016 08:41

Command to Compress a MySQL dump at highest compression level

tar cv path_to_dump.sql | xz -9 > filename.tar.xz