(Sean Hull) MySQL’s unique architecture allows for plugin storage engines. So for example, there is the MyISAM storage engine, the original one, and there is the ARCHIVE storage engine, which has characteristics that make it suitable for storing archived data. And of course we know the InnoDB stor

(Michael McLaughlin) While installing the MySQL 6.0 Alpha release, I encountered a failure running the configuration component. It shows the following dialog, which hangs until you cancel it.

(Josh Berkus) You’ve already downloaded and tested 8.4beta1 right? And sent in some good bug reports, right? You’ve tried porting your old databases to it and tested the results, right? No? Well, what are you waiting for?

(Michael McLaughlin) While working through export techniques in MySQL (5.1.34-community), I discovered that MySQL exports a null VARCHAR as a – (dash). Then, I checked the CSV engine and found that’s how MySQL stores it. It appears to be a proprietary format since other databases would import the da

(Robin Schumacher) Before we get started, let me say that I always liked being a SQL Server DBA. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL). Coming from the other databases, I found S

(Andrew Morgan) The answer is yes – kind of.

(Diego Medina) We have an Admin plugin for the MySQL Proxy, but people started asking how to use it. I only found one example, thanks to Giuseppe, but people wanted more.

(Patrick Galbraith) I’m in the process of migrating remaining functionality of Tripod.com from using Oracle to using MySQL. There were some assumptions I had made about various data types, particularly dates. One thing I discovered while converting one piece of code is the Oracle function to_char().

(Shlomi Noach) Continuing Variables ambiguities in names and values, there are two more issues I wish to present.

(Fernando Ipar) MySQL provides a SOUNDEX() function, which returns the soundex of a given string. For details, refer to the manual, but to put it simply, it allows you to compare strings based on how they sound, hence letting you do proximity searches on your database.