MySQL-dump

As a service to the busy, here are SuSE 10.0 RPMs of 5.0.19 a/o 2005-12-27 — use the spec-file to roll your own from the sources. This is a QND build, no warranty given, no responsibility taken.

As a service to the busy, here are SuSE 9.3 RPMs of 5.0.13 a/o 2005-09-09 — use the spec-file to roll your own from the sources. This is a QND build, no warranty given, no responsibility taken.

An introduction to the normalisation of databases that requires no prior knowledge and serves as an excuse to introduce cat content into MySQL-dump.

Continue reading "Nermalisation"

The most recent MySQL server I used in a production environment was a 3.23, so in conjunction with reading the 5.0 sources, I saw fit to reread large parts of the documentation to see where updates had happened, fixes were applied, extensions added. Here are some random clippings from the docs that illustrate quirks, changes from MySQL 3.23 (other than those noted in 3.23->4.0, 4.0->4.1, 4.1->5.0 which we'll give a brief tour of at the end) and differences from the standard. If you recently read the docs, kindly walk on, there's nothing to see here. If being a MySQL admin is #96 on the list of who you are, stand by for some trivia. Continue reading "A day in the docs"

By chance, I came across this interactive interactive SQL tutorial — select your preferred engine, create queries for a variety of exercises, see the results online immediately. Instructive for the beginner, possibly fun for the advanced. : )

Just out of curiosity, and partly prompted by the IDE-poll on mysql.com, I tried to import the mysql-5.0 folder into the "usual suspects" as far as linux-IDEs are concerned: Continue reading "MySQL and IDEs (import)"

As a service to the busy, here are SuSE 9.3 RPMs of 5.0.12 a/o 2005-08-30 — use the spec-file to roll your own from the sources. This is a QND build, no warranty given, no responsibility taken.

As a service to the busy, here are MySQL Query-browser 1.1.12 and MySQL Administrator 1.0.22a RPMs (SuSE 9.3, MySQL 5).
These are builds from the MySQL download section, not the repository.

Update recommended especially for the Query-Browser; the UI was improved, and I no longer get a crash I used to get with the SuSE binary.

Wherein we'll touch upon the main points of getting, building, and installing MySQL software — the main files and URLs to look at to get the developers' version from the repository, to compile, install and package it — for those living on the bleeding edge who start from scratch, and can't wait … Continue reading "Fast forward MySQL: getting, building, installing"

Seeing the MySQL cluster FAQ always puts a smile on my face.
Little things amuse little minds, I guess.

As a service to the busy, here are SuSE 9.3 RPMs of 5.0.11 a/o 2005-07-28 — use the spec-file to roll your own from the sources. This is a QND build, no warranty given, no responsibility taken.

Innobase, Oy!
Apparently, Oy is Finnish for Ltd. — ah, the possibilities are endless!