Changing the default MySQL engine to InnoDB

Specify requires that the default engine for MySQL be set to InnoDB. If your existing MySQL engine is not InnoDB use the following instructions to change your default from within the MySQL Administrator tool.

Macintosh

Launch the MySQL Administrator from within the MySQL directory of your file system.

Click on the Options button.

If necessary, click on the (Edit) button in the General section to remove the red line and allow editing.

Click on the Default Storage Engine combo box and select InnoDB from the drop-down list.

Click the Save button.

 

Windows

Launch the MySQL Administrator from within the MySQL directory of your file system.

Click on the Startup Variables button in the side bar menu.

Click on the General Parameters tab.

If necessary, check the Default Storage box in the General section of the window to allow editing.

Click on the Default Storage combo box and choose InnoDB from the drop-down list.

Click on the Apply Changes button.

 

Linux

Launch the MySQL Administrator tool from within the MySQL directory of your file system.

Click on the Startup Variables button in the side bar menu.

Click on the General Parameters tab.

If necessary, click the (Edit) button in the General section of the window to remove the red line and allow editing.

Click on the Default Storage Engine combo box and choose InnoDB from the drop-down list.

Click the Save Changes button.

 

Saving Changes

When you click the Save button you may be asked to enter your username and password. If you get a message that refers to the my.cnf file in MySQL several problems could exist. Three possibilities are that you may not have permission to change this file, the file may not exist, or the file may be old. The MySQL manual may be helpful in this situation, but if you are not able to resolve the problem please contact the Specify team at specify@ku.edu.

Also, once the changes to the default engine have been saved it is necessary to shut down and restart MySQL for the changes to take affect.