db_backup.py

import dropbox
import time
import os
 
APP_KEY = ''
APP_SECRET = ''
ACCESS_TOKEN = ""
 
TIMESTAMP = time.strftime('%Y-%m-%d')
FILENAME = "filename.sql"
TAR_XZ = "filename_" + TIMESTAMP +".tar.xz"
 
flow = dropbox.client.DropboxOAuth2FlowNoRedirect(APP_KEY, APP_SECRET)
client = dropbox.client.DropboxClient(ACCESS_TOKEN)
 
try:
    os.popen("mysqldump -u username -pPASSWORD --single-transaction database_name > " + FILENAME)
    os.popen("tar -jcf " + TAR_XZ + " " + FILENAME)
    os.popen("rm " + FILENAME)
    f = open(TAR_XZ, 'rb')
    response = client.put_file('/folder/' + TAR_XZ, f)
    f.close()
    os.popen("rm " + TAR_XZ)
    os.popen('echo "" | mail -s "Dropbox: Upload Successful" [email protected])
except Exception:
    os.popen('echo "" | mail -s "Dropbox: Error. Please investigate." [email protected]')