#!/usr/bin/env python

"""mysql-backup.py: Backups up all MySQL databases and sends them to Dropbox"""

##

# Copyright (C) 2012 Yudi Rosen (yrosen@wireandbyte.com)

#

# Permission is hereby granted, free of charge, to any person obtaining a copy of this software

# and associated documentation files (the "Software"), to deal in the Software without restriction,

# including without limitation the rights to use, copy, modify, merge, publish, distribute,

# sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is

# furnished to do so, subject to the following conditions:

#

# The above copyright notice and this permission notice shall be included in all copies or

# substantial portions of the Software.

#

# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT

# LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.

# IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,

# WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE

# SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

##

import os

import re

import socket

import sys

import time

from logentries import LogentriesHandler

import logging

import time

import pyminizip

try:

from dropbox import client, rest, session

except ImportError:

print "Need Dropbox! (https://www.dropbox.com/developers/reference/sdk)"

sys.exit(1)

try:

from hurry.filesize import size

except ImportError:

print "Need hurry.filesize! (http://pypi.python.org/pypi/hurry.filesize/)"

sys.exit(1)

# - - - - - - - - - - CONFIGURATION OPTIONS! - - - - - - - - - - #

# MySQL login info:

MYSQL_ROOT_USER = 'root'

MYSQL_ROOT_PASS = 'my-root-passsword'

MYSQL_HOSTNAME = 'localhost'

MYSQL_PORT = 3306

# Dropbox (see documentation on how to do this):

DROPBOX_KEY = 'dropbox-app-key' # Dropbox API Key

DROPBOX_SECRET = 'dropbox-app-secret' # Dropbox API Secret

DROPBOX_ACCESS = 'dropbox' # Can be 'app_folder' or 'dropbox'

DROPBOX_FOLDER = '/backups/mysql/' # Folder to use in Dropbox - with trailing slash

# Other Options:

OPTION_COMPRESS = True # compress the resulting SQL file before uploading?

COMPRESS_PASSWORD = 'password' # password for compressed file

OPTION_USE_HOST = True # Prepend the system hostname to the output filename?

OPTION_USE_DATETIME = False # Use current datetime in the output filename?

LOGENTRIES_TOKEN = 'logentries-token'

# - - - - - - - - - - END OF CONFIG OPTIONS! - - - - - - - - - - #

CURRENT_PATH = os.path.dirname(os.path.realpath(__file__))

# Dropbox token file - stores our oauth info for re-use:

DROPBOX_TOKEN_FILE = CURRENT_PATH + '/dropbox.tokens.txt'

# Directory to work in (include trailing slash)

# Will be created if it doesn't exist.

TMP_DIR = CURRENT_PATH + '/tmp/'

def get_timestamp():

"""Returns a MySQL-style timestamp from the current time"""

return time.strftime("%Y-%m-%d %T") if OPTION_USE_DATETIME == True else ''

def do_mysql_backup(tmp_file):

"""Backs up the MySQL server (all DBs) to the specified file"""

os.system("/usr/bin/mysqldump -u %s -p\"%s\" -h %s -P %d --opt --all-databases > %s" % (MYSQL_ROOT_USER, MYSQL_ROOT_PASS, MYSQL_HOSTNAME, MYSQL_PORT, TMP_DIR + tmp_file))

def connect_to_dropbox():

connect_to_dropbox() # Who doesn't love a little recursion?

def get_new_dropbox_tokens():

token_file.close()

def main():

time.sleep(10)

if __name__ == "__main__":

main()