MySQL Bugs: #68233: Feature request for the "Change the Storage Engine of All Tables" utility plugin

Bug #68233	Feature request for the "Change the Storage Engine of All Tables" utility plugin
Submitted:	31 Jan 2013 7:59	Modified:	25 Mar 2013 17:08
Reporter:	Philip Olson	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S4 (Feature request)
Version:	5.2.46	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	plugin

Description:
Two feature requests for the following option:

  Plugins->Utilities->Change the Storage Engine of All Tables

1. Report that data was changed
2. Add an optional select box similar to the engine list available in preferences

1. Reporting the data means if, for example, changing the engine from "MyISAM" to "InnoDB" succeeded, it'd say something like "The storage engine was changed for 3 tables." or it could provide more details like mention the former/current engines. If nothing changed (e.g., InnoDB was already the engine for all tables) then it could instead say that.

2. Preferences->Model: MySQL->Default Storage Engine -- has a dropdown list of possible storage engines. It may be a good idea to offer this list to the above plugin, instead of (or in addition to) a text box. And maybe also add the text box option to the aforementioned preference.

How to repeat:
See the description.

Suggested fix:
As described above, or in a similar fashion.

Thanks for your request.