MAMP / MySQL config notes for ‘Repair with keycache’ and table metadata lock

Problem: MySQL taking forever to load some large data dumps. Forever or longer. “mysql> show processlist;” shows it wedged at “Repair with keycache” and “Waiting for table metadata lock”. According to a handy Stack Overflow article, this is a known and dreaded condition, which can be addressed by making sure tmp dir has plenty of […]

Be your own twitter: laconi.ca microblog platform and identi.ca

The laconi.ca microblogging platform is as open as you could hope for. That elusive trinity: open source; open standards; and open content. The project is led by Evan Prodromou (evan) of Wikitravel fame, whose company just launched identi.ca, “an open microblogging service” built with Laconica. These are fast gaining feature-parity with twitter; yesterday we got […]

Commandline PHP for loading RDF URLs into ARC (and Twinkle for query UI)

#!/usr/bin/php <?php if ($argc != 2 || in_array($argv[1], array(‘–help’, ‘-help’, ‘-h’, ‘-?’))) { ?> This is a command line PHP script with one option: URL of RDF document to load <?php } else { $supersecret = “123rememberme”; #Security analysts recommend using data of birth + social security ID here # *** be careful with real […]

OpenID plugin for WordPress

I’ve just installed Alan J Castonguay’s WordPress OpenID plugin on my blog, part of a cleanup that included nuking 11000+ comments in the moderation queue using the Spam Karma 2 plugin. Apologies if I zapped any real comments too. There are a few left, at least! The OpenID thing appears to “just work”. By which […]

GIS and Spatial Extensions with MySQL

GIS and Spatial Extensions with MySQL. MySQL 4.1 introduces spatial functionality in MySQL. This article describes some of the uses of spatial extensions in a relational database, how it can be implemented in a relational database, what features are present in MySQL and some simple examples. I’m hoping to understand the commonalities between this and […]

Missed me, huh?

Blog was broken for weeks. Note to self for next time: Mysql password forgettage: restart it with –skip-grant-tables and run “mysql -u root mysql” Then… UPDATE user SET Password=PASSWORD(‘sekretsekret’) WHERE User=’root’; …and before all this, have backed it all up. REPAIR TABLE wordpress.wp_categories; …etc to fix up trashed tables. Then restart the mysqld with normal […]