on my mySQL5 installation it created InnoDB tables with everything when I migrated all my 4.x stuff over from another server. I haven't noticed any deleterious effects (i.e. slowing stuff down since we all know myISAM is real fast) and in fact I have seen an increase in stability; given that there was one particular error that I could expect a myISAM table to throw every month or so and I haven't had a single problem yet. But that could be mySQL5 being more stable than 4.x too.
Unless you have a specific reason for myISAM I would use innoDB. Its a more robust table type in general. Just not as fast. -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
