Peter Mescalchin magnetikonline

WordPress database clean up queries

Orphan rows
Other

Nginx FastCGI cache

Example /etc/nginx/nginx.conf using FastCGI (e.g. to PHP-FPM) with FastCGI cache enabled. This will capture returned data and persist it to a disk based cache store for a configurable amount of time, great for robust full page caching.

Will need to create a directory to hold cache files, for the example given here that would be:

$ sudo mkdir -p /var/cache/nginxfastcgi
$ chown www-data: /var/cache/nginxfastcgi

Update WordPress URL paths

PHP script that takes a mysqldump file and brute force replaces URLs into an output dump file.

Ensure to dump the source SQL database using the --skip-extended-insert switch to ensure INSERT INTO() statements don't end up on singular and very long lines, which won't help the script crunch all the replacements.

E.g.

$ mysqldump \
	-hlocalhost -uUSERNAME -p \

Installing Sass 3.3.5 on Ubuntu 12.04LTS

Uninstall anything ruby related

$ dpkg --list | grep ruby
$ sudo apt-get purge [ruby-package]
$ sudo apt-get purge [ruby-package]
$ sudo apt-get purge [ruby-package]
# etc...

Check Linux filesystem for bad blocks

List filesystem(s) to check

$ df -h

Will be listed as /dev/sdX1.

	<?php
	// using generators (yield) to recursively read files from a source path
	// more: http://www.php.net/manual/en/language.generators.php

	foreach (readFileSubDir('~/testdir') as $fileItem) {
	echo($fileItem . "\n");
	}


	function readFileSubDir($scanDir) {

	<?php
	$testExpression = '/(?i)te(?-i)st/';

	testPCRESectionOnly($testExpression,'test');
	testPCRESectionOnly($testExpression,'TEst');
	testPCRESectionOnly($testExpression,'teST');
	testPCRESectionOnly($testExpression,'TEST');

	/*
	Should return:

	#!/bin/bash -e

	if [[ -z $1 ]]; then
	echo "Usage: $(basename "$0") [Gist ID/SHA1]"
	exit 1
	fi

	# create temp directory, clone Gist
	gitTempDir=$(mktemp --directory "/tmp/gistreset.XXXXX")
	git clone "[email protected]:$1" "$gitTempDir"

	IgnoreAgent +http://www.baidu.com/search/spider.html)
	IgnoreAgent ; 360Spider
	IgnoreAgent ; Claritybot)
	IgnoreAgent ; Google Web Preview)
	IgnoreAgent ; Googlebot
	IgnoreAgent Aboundex/*
	IgnoreAgent Apache-HttpAsyncClient/*
	IgnoreAgent Apache-HttpClient/*
	IgnoreAgent AppEngine-Google*
	IgnoreAgent Baiduspider*

	// creates a window.nextTick(handler) method with support for IE8+
	// emulating Node.js process.nextTick() method
	// http://nodejs.org/api/process.html#process_process_nexttick_callback
	// note: IE8 will use a zero time setTimeout, which should fire within 4-10ms
	(function(win) {

	var NEXT_TICK_MESSAGE_NAME = 'next-tick',
	nextTickHandlerList = [];

	if (win.addEventListener) {