ryenus

OSX How To: Uninstall native MySQL and install MariaDB via Homebrew

This is a short overview on how to completely remove any old mysql server installs in OSX and upgrade to MariaDB without conflicts. Things can get a bit weird when you have various old installs of MySQL server floating around, and utilizing homebrew to install and upgrade MariaDB as a drop in replacement for MySQL has worked well, especially if you're used to managing MySQL installs via yum in linux.

First: Backup Your Data!

Backup all of your current databases with mysqldump

This isn't a tutorial on backups, and there are many ways to do it. You should know how to backup your data anyway. For this example, we'll do a full backup of our InnoDB databases.

	# Install GIT Client on SuSE 11 SP3

	# for latest git
	zypper addrepo http://download.opensuse.org/repositories/devel:/tools:/scm/SLE_11_SP3/devel:tools:scm.repo
	# for perl-Error
	zypper addrepo http://download.opensuse.org/repositories/devel:/languages:/perl/SLE_11_SP3/devel:languages:perl.repo

	# Install packages
	zypper install git

	<script>
	// Charles Lawrence - Feb 16, 2012. Free to use and modify. Please attribute back to @geuis if you find this useful
	// Twitter Bootstrap Typeahead doesn't support remote data querying. This is an expected feature in the future. In the meantime, others have submitted patches to the core bootstrap component that allow it.
	// The following will allow remote autocompletes without modifying any officially released core code.
	// If others find ways to improve this, please share.

	var autocomplete = $('#searchinput').typeahead()
	.on('keyup', function(ev){

	ev.stopPropagation();

	#!/usr/bin/env ruby -w
	## Using ruby's standard OptionParser to get subcommand's in command line arguments
	## Note you cannot do: opt.rb help command
	## other options are commander, main, GLI, trollop...

	# run it as
	# ruby opt.rb --help
	# ruby opt.rb foo --help
	# ruby opt.rb foo -q
	# etc

	Originally:
	https://gist.github.com/7565976a89d5da1511ce

	Hi Donald (and Martin),

	Thanks for pinging me; it's nice to know Typesafe is keeping tabs on this, and I
	appreciate the tone. This is a Yegge-long response, but given that you and
	Martin are the two people best-situated to do anything about this, I'd rather
	err on the side of giving you too much to think about. I realize I'm being very
	critical of something in which you've invested a great deal (both financially