Oliver Grimm pixelpogo

I hereby claim:

I am pixelpogo on github.
I am pixelpogo (https://keybase.io/pixelpogo) on keybase.
I have a public key whose fingerprint is 9483 351B 825B EE02 3AD2 9889 ED80 7C71 E623 BD51

To claim this, I am signing this object:

	# try
	# 48kbit/s for Dialup
	# 64kbit/s for Edge
	# 384kbit/s for 3G
	# 768kbit/s for DSL
	# 1572kbit/s for T1
	#
	# to simulate low bandwidths.
	#
	# And: You can play with the delay option.

	export DYLD_LIBRARY_PATH="/usr/local/mysql/lib:$DYLD_LIBRARY_PATH"
	env ARCHFLAGS="-arch x86_64" gem install mysql -v='2.8.1' -- --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib --with-mysql-include=/usr/local/mysql/include --with-mysql-config=/usr/local/mysql/bin/mysql_config


	# and add this line to your .bash_profile
	# export DYLD_LIBRARY_PATH="/usr/local/mysql/lib:$DYLD_LIBRARY_PATH"

	An example:

	During the import of a big sql-dump MySQL encountered an error in Line 8131086:
	ERROR 1449 (HY000) at line 8131086: The user specified as a definer ('foo'@'%') does not exist

	To fix that problem I had to have a look at this specific line and, to get the context, ten lines before and after that line.
	This is how I did it:

	$ sed -n '8131076,8131096p' ~/Downloads/dump_2012-12-17.sql

	# add this to your my.cnf

	# in [mysqld]:
	innodb_file_per_table # one file for each table
	skip-character-set-client-handshake # ignore other charsets than utf8
	collation_server=utf8_unicode_ci
	character_set_server=utf8
	default_storage_engine=INNODB

	require "rubygems"
	require "aws-sdk"
	require "hirb"

	extend Hirb::Console

	ec2 = AWS::EC2.new(
	:access_key_id => 'YOUR_ACCESS_KEY_ID',
	:secret_access_key => 'YOUR_SECRET_ACCESS_KEY')

	# In your Uberspace account's $HOME directory do...

	# Clone drush git repo
	git clone --branch master http://git.drupal.org/project/drush.git

	# Checkout the correct git branch
	cd drush && git checkout 8.x-6.x

	# Add drush/bin/drush to your .zshrc/.bashrc/.bash_profile file
	echo "export PATH=$PATH:$HOME/drush" \| cat >> ~/.zshrc

	# download and install Oh-my-ZSH
	curl -L https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh \| sh

	# make zsh your default shell
	chsh -s /bin/zsh