Setting the database engine type in MySQL

First you will need to log into the mysql server using the client.  Make sure you are a privileged user.  From here you will be able to set the database engine type:

set GLOBAL storage_engine=’InnoDb’;
set GLOBAL storage_engine=’MyISAM’;

Choose carefully!

Be the first to comment

Leave a Reply