MySQL Bind Address
Submitted by TimBruce on Mon, 2009-08-17 17:12There are times when you need MySQL to be able to bind to more than one address. In this particular occasion, I was running Nagios locally on the same system as Drupal, my content management system.
Finding info in Files
Submitted by TimBruce on Wed, 2009-07-08 12:42Sometimes you want to be able to quickly search the contents of some files for a command or some other piece of text. The following command (for Cygwin obviously) will work:
for i in `find /cygdrive/c/Devel/SQL/ | grep sql `; do echo $i; grep cursor $i; done;
QEMU on Windows
Submitted by TimBruce on Wed, 2009-07-08 12:04Download the QEMU program (from http://www.h7.dion.ne.jp/~qemu-win/) and install it into a directory on Windows. I use C:\QEMU.
Verified Updates in SQL
Submitted by TimBruce on Thu, 2009-07-02 17:36Sometimes, on a high-volume / high TPS database, I want to make sure I've made updates to ALL the recovers, and not leave some orphaned data out there. This usually occurs because someone has a locked record while they're making a change. So when I'm making updates to multiple records (remember, SQL is SET based, so it applies to all records that match a condition), I use a belt and suspenders approach.
Second Network Address on same NIC
Submitted by TimBruce on Mon, 2009-05-25 11:32Sometimes you need to bind a second IP address to a Network Interface Card. Maybe you need access to another network temporarily or you just need to fix something that comes with a default address not on your network.
From Linux, you can execute the following command:
ifconfig eth0:1 192.168.5.16 netmask 255.255.255.0 up
This will add a second IP Address to your eth0 network interface.
