I posted this on stackoverflow, but was advised that here might be better...
I am planning an upgrade of some MySQL servers (5.1 to 5.5). I am aware that the InnoDB plugin is now built in to MySQL.
Currently we use the InnoDB plugin...
When upgrading to 5.5, is it just a case of removing the relevant lines in my.ini that load the plugin before restarting the server, or is there something I need to do (or should be doing) to the databases and tables in addition to this to take account of the change?
Will the tables just "pick up" the change to the storage engine, or do they need to be converted in some way.
I don't intend on doing a dump and reload of the tables as there are many large databases and this would be a bit of a pain!
Hope this all makes sense!