Simple scripts to backup MySQL and Web Content

backup-mysql

#!/usr/bin/env python
import os
import time

# Variables
username = 'backup'
password = 'password'
hostname = 'localhost'
filestamp = time.strftime('%Y%m%d')

# Save all
database_list_command = "mysql -u%s -p%s -h%s --silent -N -e 'show databases'" % (username, password, hostname)
for database in os.popen(database_list_command).readlines():
    database = database.strip()
    if database == 'information_schema' or database == 'performance_schema' or database == 'mysql':
        continue
    filename = "/backup/mysql/%s-%s.sql" % (database, filestamp)
    print "Backing up %s" % filename
    os.popen("mysqldump -u%s -p%s -h%s -e --opt -c %s | gzip -c -9 > %s.gz" % (username, password, hostname, database, filename))
    print ".. done"

backup-run

#!/bin/sh
~/backup/mysql
~/backup/www
~/backup/s3

backup-s3

#!/bin/sh
s3cmd sync /backup/ s3://yourbucket/`hostname`/

backup-www

#!/bin/sh
tar -czvf /backup/www/`date +%Y%m%d`.tar.gz /var/www

install-s3

#!/bin/sh
wget -O- -q http://s3tools.org/repo/deb-all/stable/s3tools.key | sudo apt-key add -
wget -O/etc/apt/sources.list.d/s3tools.list http://s3tools.org/repo/deb-all/stable/s3tools.list
apt-get update
apt-get install -y s3cmd