#!/usr/bin/env python

# Version: 1.0

# Author:
# Andreas Glaser aka JaZz
# www.andreas-glaser.com

# Requirements:
# python, mysqldump, bzip2
# Debian Install: apt-get install python mysqldump bzip2

# 1. Import
from time import gmtime, strftime
import subprocess

# 2. Config
MysqlUser = "root";
MysqlPwd = "YOUR_PASSWORD";
MysqlDatabase = "--all-databases";
DumpDir = "/tmp/";
DumpFile = "mysqldump-" + strftime("%Y-%m-%d-%H-%M-%S", gmtime()) + ".sql";

# 3. Process
print strftime("%Y-%m-%d-%H-%M-%S", gmtime()) + ": Mysqldump started";
subprocess.call("mysqldump --user " + MysqlUser + " --password=" + MysqlPwd + " --force --flush-privileges --compress --comments " + MysqlDatabase + " > " + DumpDir + DumpFile, shell=True);
subprocess.call("bzip2 -9v " + DumpDir + DumpFile, shell=True);
print strftime("%Y-%m-%d-%H-%M-%S", gmtime()) + ": Mysqldump finished";