Simple MySQL Diff

Dead simple way to diff two MySQL databases (probably applicable to others as well).  Just create a new file with the following:

#!/bin/sh

mysqldump database1 --no-data -u username -p > db1.sql
mysqldump database2 --no-data -u username -p > db2.sql
diff db1.sql db2.sql | grep \( -B 1

Make sure to chmod o+x the file to enable execution. This will output the locations of changes in your databases, and you can go to the line numbers to find the actual changes.

How to Disable Strict Host Key Checking on Local Network

If you do a lot of ssh-ing on a local network with constantly changing hardware, you’re going to run into problems where stored known RSA keys don’t match up if the next device to use an IP address has a different signature.

Something like:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that a host key has just been changed.
The fingerprint for the RSA key sent by the remote host is
e8:73:0c:61:f8:cc:4c:95:25:ed:76:bc:35:bc:5d:c4.
Please contact your system administrator.
Add correct host key in /home/heidi/.ssh/known_hosts to get rid of this message.
Offending RSA key in /home/heidi/.ssh/known_hosts:1
remove with: ssh-keygen -f "/home/sam/.ssh/known_hosts" -R 192.168.1.25
RSA host key for 192.168.1.25 has changed and you have requested strict checking.
Host key verification failed.

To fix this, just add the following lines above Host * in your ssh config file. This file can be found at /etc/ssh/ssh_config on Ubuntu systems, but might be somewhere else on your system. You’ll need to sudo edit it to make changes.

Host 192.168.1.*
StrictHostKeyChecking no
UserKnownHostsFile /dev/null

You can also specify other settings if you’d like, such as default user and port.

Updating to SVN 1.8 for Mac OSX 10.8

Updated and based off http://jason.pureconcepts.net/2012/10/updating-svn-mac-os-x/

Note: To compile and install SVN 1.8 you need Xcode with the Command Line Tools installed.  This has been tested with SVN 1.8.0 on Mac OSX 10.8 with XCode 4.6.3.

Download the SVN Source

cd ~/Downloads/
curl -o subversion-1.8.0.tar.gz http://archive.apache.org/dist/subversion/subversion-1.8.0.tar.gz
tar -xvf subversion-1.8.0.tar.gz

Build and Install SVN

The default SVN install on Mac OS X uses neon, however the new 1.8 version of SVN only supports serf.

First, create a symlink to your toolchain:

sudo ln -s /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/ /Applications/Xcode.app/Contents/Developer/Toolchains/OSX10.8.xctoolchain

Then do:

cd ~/Downloads/subversion-1.8.0
sh get-deps.sh serf
cd serf/
./configure
make
sudo make install
cd ..
./configure --prefix=/usr/local --with-serf=/usr/local/serf
make
sudo make install

Almost done…

To use the SVN version you just installed, you need to update your PATH.

Add or edit the following line in your ~/.bash_profile:
export PATH=/usr/local/bin:$PATH

Your system should now report using SVN 1.8.0
svn --version

Mahi Mahi with Eggs

image

 

Pour a bunch of lime juice on the Mahi Mahi.  Add salt and pepper.  A little bit of ginger.

Flip it, do the same on the other side.  Let it sit for 10 minutes in the fridge.

Heat a pan on medium heat with coconut oil.

Add the fish when its hot.

While the fish is cooking, crack some eggs and mix until they are mixed.

Cook fish until both sides have a discernible brown tint around the edges.

Plate the fish, and add the eggs to the same pan.  You may want to add some more oil if there isn’t enough.

Move the eggs around continuously in the pan.

Plate the eggs, add salt, pepper, and hot sauce.