Upgraded my mySQL server from 3.23.58 to 4.1.11 – all in one fell swoop.

Except for a white space I inserted in a config file that I should not have, an unbelievably simple and not complicated upgrade. Swap out the engine, change some config files…don’t touch the data files (MYD,MYI,frm) – yep, kept ISAM tables.

And it worked. Huh! I like that…

And now I get sub-selects! *Shrug* Again, this is why people flame mySQL – this should have been in there l.o.n.g ago.

To me.

But now I’m a happy pseudo-DBA.