Onnay Okheng onnayokheng

THIS GIST IS NOW A COMMUNITY MANAGED REPOSITORY. CLICK HERE TO BE TAKEN TO THE NEW LOCATION!

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

Share Counts

I have always struggled with getting all the various share buttons from Facebook, Twitter, Google Plus, Pinterest, etc to align correctly and to not look like a tacky explosion of buttons. Seeing a number of sites rolling their own share buttons with counts, for example The Next Web I decided to look into the various APIs on how to simply return the share count.

If you want to roll up all of these into a single jQuery plugin check out Sharrre

Many of these API calls and methods are undocumented, so anticipate that they will change in the future. Also, if you are planning on rolling these out across a site I would recommend creating a simple endpoint that periodically caches results from all of the APIs so that you are not overloading the services will requests.

Twitter

Linux

Setup

# If inside vmware install vmware tools (these are just as good as the commercial ones)
sudo apt-get install open-vm-tools open-vm-tools-desktop

# Install git
sudo apt-get install git

	#
	# @author Jonathon byrd
	#

	############################################################
	# first things first, set your iptables for a web server. If you jack these
	# up you don't want to have to re-install your os after doing much more.
	# @see http://www.thegeekstuff.com/2011/06/iptables-rules-examples/
	# and
	# @see https://help.ubuntu.com/community/IptablesHowTo

	#301 Redirects for .htaccess

	#Redirect a single page:
	Redirect 301 /pagename.php http://www.domain.com/pagename.html

	#Redirect an entire site:
	Redirect 301 / http://www.domain.com/

	#Redirect an entire site to a sub folder
	Redirect 301 / http://www.domain.com/subfolder/

	((d, s, id) ->
	js = undefined
	fjs = d.getElementsByTagName(s)[0]
	return if d.getElementById(id)
	js = d.createElement(s)
	js.id = id
	js.src = "//connect.facebook.net/en_US/all.js#xfbml=1"
	fjs.parentNode.insertBefore js, fjs
	) document, "script", "facebook-jssdk"

	// This gist is now maintained on github at https://github.com/luetkemj/wp-query-ref

	<?php
	/**
	* WordPress Query Comprehensive Reference
	* Compiled by luetkemj - luetkemj.github.io
	*
	* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
	* Source: https://core.trac.wordpress.org/browser/tags/4.9.4/src/wp-includes/query.php
	*/

	<?xml version='1.0' encoding='UTF-8'?>
	<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN"
	"http://www.apple.com/DTDs/PropertyList-1.0.dtd" >
	<plist version='1.0'>
	<dict>
	<key>Label</key><string>org.macports.mongodb</string>
	<key>ProgramArguments</key>
	<array>
	<string>/opt/local/bin/daemondo</string>
	<string>--label=mongodb</string>

	<?php
	/**
	* Setup wp_query arguments for the loop. Cache the results for 4 hours.
	*
	* @link http://codex.wordpress.org/Transients_API
	*/

	// Check for transient
	if ( false === ( $my_query = get_transient( 'foo_featured_posts' ) ) ) {