kaiserama

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"

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

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

	from MySQLdb import cursors
	from flask import request

	class DataTablesServer(object):

	def __init__( self, request, columns, index, table, cursor):
	self.columns = columns
	self.index = index
	self.table = table
	# values specified by the datatable for filtering, sorting, paging

	class LoginForm(Form):
	email = TextField('Email', validators=[Required()])
	password = PasswordField('Password', validators=[Required()])
	remember = BooleanField('Remember Me', default=True)


	class UserRole(db.Model):
	__tablename__ = 'user_role'
	id = db.Column('user_role_id', db.Integer, primary_key=True)
	user_id = db.Column(db.Integer, db.ForeignKey('user.user_id'))

	<h1>
	Test Charges
	</h1>
	<p>Your credit card will charged later.</p>
	<form action="{{ url_for('charge_test') }}" id="pay_form" class="pull-right" method="post">
	<script src="https://checkout.stripe.com/v2/checkout.js" class="stripe-button" data-key="{{ key }}" data-name="Application Name Here" data-description="Test Reservation" data-amount="5000"></script>
	</form>