It is recommended to keep the default storage engine as MyISAM. However, if you wish to change it, you can do so by following the guidelines below:ut should you wish to change it you can do so by following the following guide line:

To change the storage engine from the default MyISAM to InnoDB, edit the my.ini file. This can be achieved by selecting the WampServer icon, navigating to MySQL, and choosing my.ini. Then, make the following amendment:

Find and comment/uncomment or add the following two lines:

;default_storage_engine=MYISAM

default_storage_engine=InnoDB


It is recommended to avoid using InnoDB for importing CSV files, as its use of fixed column lengths can result in data being truncated or missed.



Topic last reviewed: 15/04/26