Index

Converting all tables in MySQL DB to InnoDB

#!/bin/bash exit 1 dbname="eorder" echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t | mysql $dbname Read More »
By halfgaar, 8 months ago, on October 02, 2012, at 14:10 | 5 comments

Translating Dutch programming error messages

In .NET, you get Dutch errors when your Windows is in Dutch, which is hugely annoying. You can use this site to translate them, so that you can Google them. Read More »
By halfgaar, 9 months ago, on August 09, 2012, at 15:08 | No comments

My universal remote programming codes

Whenever this remote's battery is loose for a while, it forgets its programming. So, here it is: For computer, use the TV setting. Press 1 and 3 for a few seconds, then when the light turns on, enter 0677 as code. Read More »
By halfgaar, 9 months ago, on August 06, 2012, at 21:08 | No comments

Kart racing scores

I want to keep track of my kart racing scores: dateTrackRacerfastest Time 2012-07-24Long BeachWiebe55.95 2012-07-24Long BeachWiebe56.22 2012-07-24Long BeachWiebe58.84 Read More »
By halfgaar, 10 months ago, on July 25, 2012, at 15:07 | No comments

Apache mod_proxy configuration for The Pirate Bay

I found several apache mod_proxy configs for setting up a proxy for The Pirate Bay, but none worked fully. Read More »
By halfgaar, 10 months ago, on July 13, 2012, at 16:07 | 5 comments

Listing MySQL table sizes

This query lists the sizes of all tables in MySQL: SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), 'MB') DATA, CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), 'MB')FREE from information_schema.TABLES where TABLE_SCHEMA NOT IN ('information_schema','mysql', 'performance_schema'); Read More »
By halfgaar, 10 months ago, on July 12, 2012, at 13:07 | No comments

How to test payformystay.com

I haven't got much experience when it comes to testing web applications. Instead (and more so out of apathy than belief), I've always adhered to the ad-hoc test approach. However, the usage of pure Posgres unit tests back when I worked on a complicated investment database with Halfgaar did teach me the advantages of test-driven development. Read More »
By Rowan Rodrik, 1 year ago, on May 19, 2012, at 13:05 | 5 comments

Generating an SSL CSR and key

To generate an SSL certificate signing request (CSR) with key you can do this: openssl req -nodes -newkey rsa:2048 -keyout bla.key -out bla.csr Read More »
By halfgaar, 1 year ago, on May 10, 2012, at 15:05 | No comments

Creating a drbd for an existing Xen domain

I needed some VMs to be available on a backup node, which I accomplished with the distributed remote block device, or DRBD. My host machine is Debian 6. Read More »
By halfgaar, 1 year ago, on May 01, 2012, at 18:05 | 1 comment

Internet Explorer in VirtualBox 4.1 in Ubuntu 10.10

I've been needing IE for testing payformystay.com for some time now, but now I'm studying and I need it to work with some interactive Silverlight stuff. Read More »
By Rowan Rodrik, 1 year ago, on April 16, 2012, at 14:04 | No comments