On 10/25/05, Matt Robertson <[EMAIL PROTECTED]> wrote: > Anyone have any thoughts on installation and upgrading from mySQL 4? > IIRC CF no longer ships with the proper drivers for anything past v4 > (if at all, I guess). Doing a CF 7 installation in a couple days on a > new server.
Not sure if you're asking about upgrading MySQL itself from 4->5 or using the MySQL JDBC drivers on CF7.... If you're asking about 4->5 upgrades, the answer is in general, it's smooth. MySQL always ships upgrade scripts for databases with each release and IF YOU FOLLOW THE DIRECTIONS (generally emphasis, not aimed at you directly) you should have no problems. http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html In my experience, you usually want to upgrade one increment at a time, for example: 3.23.x -> 4.0 -> 4.1 -> 5.0 Skipping intervening dbs should be ok, but there are so many changes in the major releases, it's sometimes better just to dump it out and recreate it unless you're running a realy vanilla (all MyISAM, no internationalization, etc) database -- which actually is the situation for most folks using MySQL. Note that you WILL have to use the fix_privileges() script if you're upgrading from a pre 5.0 version since permissions for the new storedproc feature were added since 4.1 As far as MySQL JDBC drivers go, the fundamental issue with the ones (3.23.x) that ship with CFMX is that MySQL 4.1.1 introduced a different password hashing algorithm. You've got a lot of options, including using old-style passwords on a per-server basis using my.cnf file. etc or on a per-user basis using the OLD_PASSWORD() function to create passwords in the old format. IMHO, a better option is to use the new MySQL drivers, which will also be crucial if you want any of the new MySQL functionality. You can install them as an "Other" driver type using the MM technote at ttp://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 > -- > --mattRobertson-- > Janitor, MSB Web Systems > mysecretbase.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
