If you are not a DBA, as is in my case, debugging SQL errors can get tricky and cryptic. An error message like MySQL has left you or General error: 1005 Can’t create table ‘./db_name/table_name.frm’ won’t mean much to you and trying to figure out the problem can be a pain. After some googling and [...]

If you have noticed the earth move or shift this past weekend, do not fear I have the answer. This was the result of the evil planning of Baron “Xaprb” Schwartz who had the genius idea of inviting every big name in the open source database community for the OpenSQL Camp. The list of attendees [...]

I recently migrated our Subversion repositories and trac sites from one server to another. This gave me the chance to reorganize our layout and authentication mechanism. I chose to replace our existing .htaccess files with mod_auth_mysql because it fit two key criteria: It’s easy to administer – Logging into the server and running htpasswd every [...]