Shane Robinson CodeShane

Backup MySQL to Amazon S3

This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)

Sister Document - Restore MySQL from Amazon S3 - read that next

1 - Install s3cmd

this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

Selenium with Python

Author:	Baiju Muthukadan
Email:	baiju.m.mail AT gmail.com
Version:	0.3.2

The Best of the Best Practices (BOBP) Guide for Python

A "Best of the Best Practices" (BOBP) guide to developing in Python.

In General

Values

"Build tools for others that you want to be built for you." - Kenneth Reitz
"Simplicity is alway better than functionality." - Pieter Hintjens

SQL to MongoDB Mapping Chart

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

	# http://aws.amazon.com/amazon-linux-ami/
	# http://aws.amazon.com/amazon-linux-ami/faqs/

	# Boot up a machine with at least 1.5 to 2 GB Ram

	# login
	chmod 600 key.pem
	ssh -i key.pem ec2-user@ec2...compute.amazonaws.com

	# update

	#!/bin/sh
	parse_yaml() {
	local prefix=$2
	local s='[[:space:]]' w='[a-zA-Z0-9_]' fs=$(echo @\|tr @ '\034')
	sed -ne "s\|^\($s\)\($w\)$s:$s\"\(.*\)\"$s\$\|\1$fs\2$fs\3\|p" \
	-e "s\|^\($s\)\($w\)$s:$s\(.*\)$s\$\|\1$fs\2$fs\3\|p" $1 \|
	awk -F$fs '{
	indent = length($1)/2;
	vname[indent] = $2;
	for (i in vname) {if (i > indent) {delete vname[i]}}

	# Load Json into a Python object

	import urllib2
	import json
	req = urllib2.Request("http://localhost:81/sensors/temperature.json")
	opener = urllib2.build_opener()
	f = opener.open(req)
	json = json.loads(f.read())
	print json
	print json['unit']

	# -- coding: utf-8 --
	from bottle import route, run


	@route('/')
	def index():
	return '<h1>Hello World/h1>'


	run(host='localhost', port=8000)

	import unittest, os, os.path, sys, urllib
	import tornado.database
	import tornado.options
	from tornado.options import options
	from tornado.testing import AsyncHTTPTestCase

	# add application root to sys.path
	APP_ROOT = os.path.abspath(os.path.join(os.path.dirname(__file__), '..'))
	sys.path.append(os.path.join(APP_ROOT, '..'))