[thelist] MySQL subquery

[Hassan Schroeder]

Mark Groen wrote:

>>upgrade to 4.1, considering 5.0 is now in production, 4.0 is becoming
>>obsolete.
> 
> I'll talk to whom this belongs to and see what I can do, they should be
> at least at 4.1 you would think, below that is being a bit too ultra
> cautious, and maybe even detrimental methinks.

Yes, definitely, but -- test *thoroughly* before you cut over, if
the DBs in question are storing non-latin1 text.

There are big differences in the way MySQL 4.0 and 4.1 handle the
whole issue of character sets and collations, and that can require
some fiddling with table definitions, driver configs, etc.

And do *not* try to just upgrade the installation using the existing
database files. Install 4.1, use mysqldump to get the data from the
old database and then "restore" it into the new one. You may find
yourself doing this several times to get all the character set stuff
squared away...

Caveat upgrader! :-)

-- 
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                          dream.  code.