On 10/25/05, John C. Bland II <[EMAIL PROTECTED]> wrote: > Just so you know, I upgraded from 4.1 to 5 earlier and all I did was install > 5, copy db's to 5's directory, setup all users (could've probably found an > easier way but I only needed two...strictly a dev db),
That's what the fix_privileges script is for -- all that info is stored in your mysql database (the database *named* mysql). Recreating a couple of users is easy, as you suggest, but for production systems, you want to guarentee everything is the same, so an in-place upgrade of the db is a much better choice. You could amend your approach to "Copy all of the databases to 5's directory, ran the fix_privileges on the mysql database, and was ready to go". That way, you've still got both dbs available. Of course it gets trickier if you're dealing with innodb tables or anything else other than MyISAM. and remove the > 4.1instance. Oh, I had to restart 5 after that but no sweat. > All-in-all, > without my forgetting to restart 5, it took like 20 minutes including > download time. > > I understand your hesitation though. If this was a live box I probably > would've felt the same way. > > On 10/25/05, Matt Robertson <[EMAIL PROTECTED]> wrote: > > > > On 10/25/05, John Paul Ashenfelter <[EMAIL PROTECTED]> > > wrote: > > > Not sure if you're asking about upgrading MySQL itself from 4->5 or > > > using the MySQL JDBC drivers on CF7.... > > > > Actually, both although the questions were poorly worded. Thanks. > > You told me what I needed to know. I hate to say it but I'll probably > > leave my main mysql server alone for the simple reason its running > > like 40 web sites and ... well, its working fine. I'd like the new > > functionality but I can't risk the consequences of a mistake, even for > > a weekend afternoon or so. I'll save this for when I add a new > > server. > > > > -- > > --mattRobertson-- > > Janitor, MSB Web Systems > > mysecretbase.com <http://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:222300 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
