Eric Magnuson ericmagnuson

I hereby claim:

To claim this, I am signing this object:

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

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

	#!/bin/bash
	#
	# Written by Michael Conigliaro <[email protected]>
	# Updated by Eric Magnuson <[email protected]>
	# MIT License (http://opensource.org/licenses/MIT)
	#
	# This script configures WordPress file permissions based on recommendations
	# from http://codex.wordpress.org/Hardening_WordPress#File_permissions
	#
	# Instructions:

	#!/bin/bash
	#
	# Updates the entire system. Booyah.

	set -e

	start=`date +%s`

	printf '%*s\n' '80' '' \| tr ' ' =
	printf "\| Upgrades starting.\n"

	# To remove the autohide delay and speed up the transition, run this in Terminal:
	defaults write com.apple.dock autohide -bool true \
	&& defaults write com.apple.dock autohide-delay -float 0 \
	&& defaults write com.apple.dock autohide-time-modifier -float 0.3 \
	&& killall Dock

	# To revert back to default settings, run this:
	defaults delete com.apple.dock autohide \
	&& defaults delete com.apple.dock autohide-delay \
	&& defaults delete com.apple.dock autohide-time-modifier \

	##############
	# Basic LAMP #
	##############

	## Set root password (generate random password with `openssl rand -hex 5`)
	passwd

	## Update package sources
	aptitude update

	# Preview available at http://eri.cm/PRL

	function get_pwd() {
	echo "${PWD/$HOME/~}"
	}

	PROMPT='%{$fg_bold[white]%}☁ %{$fg_bold[cyan]%} %{$fg[yellow]%}$(get_pwd)%{$fg_bold[cyan]%}$(git_prompt_info)%{$fg_bold[blue]%} % %{$fg_bold[white]%}→%{$reset_color%} '

	ZSH_THEME_GIT_PROMPT_PREFIX=" %{$fg[green]%}%{$fg[cyan]%}"
	ZSH_THEME_GIT_PROMPT_SUFFIX="%{$reset_color%}"

	<IfModule mod_rewrite.c>
	RewriteEngine on

	RewriteRule (.*\.min.css) less.php?min=yes&path=$1
	RewriteRule (.*\.css) less.php?min=no&path=$1
	</IfModule>