mark erdmann markerdmann

Restore MySQL from Amazon S3

This is a hands-on way to pull down a set of MySQL dumps from Amazon S3 and restore your database with it

Sister Document - Backup MySQL to Amazon S3 - read that first

# Set our variables

export mysqlpass="ROOTPASSWORD"

	#See: http://daringfireball.net/2010/07/improved_regex_for_matching_urls
	import re, urllib

	GRUBER_URLINTEXT_PAT = re.compile(ur'(?i)\b((?:https?://\|www\d{0,3}[.]\|[a-z0-9.\-]+[.][a-z]{2,4}/)(?:[^\s()<>]+\|\(([^\s()<>]+\|(\([^\s()<>]+\)))\))+(?:\(([^\s()<>]+\|(\([^\s()<>]+\)))\)\|[^\s`!()\[\]{};:\'".,<>?\xab\xbb\u201c\u201d\u2018\u2019]))')

	for line in urllib.urlopen("http://daringfireball.net/misc/2010/07/url-matching-regex-test-data.text"):
	print [ mgroups[0] for mgroups in GRUBER_URLINTEXT_PAT.findall(line) ]

	-- Remove the history from
	rm -rf .git

	-- recreate the repos from the current content only
	git init
	git add .
	git commit -m "Initial commit"

	-- push to the github remote repos ensuring you overwrite history
	git remote add origin [email protected]:<YOUR ACCOUNT>/<YOUR REPOS>.git

	"""
	A deep neural network with or w/o dropout in one file.

	License: Do What The Fuck You Want to Public License http://www.wtfpl.net/
	"""

	import numpy, theano, sys, math
	from theano import tensor as T
	from theano import shared
	from theano.tensor.shared_randomstreams import RandomStreams

	postgres:
	image: postgres:9.4
	volumes:
	- ./init.sql:/docker-entrypoint-initdb.d/init.sql

	// swap the keybindings for paste and paste_and_indent
	{ "keys": ["super+v"], "command": "paste_and_indent" },
	{ "keys": ["super+shift+v"], "command": "paste" }