Setting the database engine type in MySQL

Computer MySQL 0

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!

Leave a Reply Cancel reply

You must be logged in to post a comment.

The field of computers is very vast and can somtimes be extremely challenging, but also very rewarding. One will often times encounter problems that they may not have the answer to. Problems don't always have solutions, but sometimes they do. And helpting to provide some of those solutions is our mission. It is our goal to provide helpful computer how to, tutorial, example, and review for the benefit of everyone.
Some funny jokes... "Dating a girl is just like writing software. Everything's going to work just fine in the testing lab (dating), but as soon as you have contract with a customer (marriage), then your program (life) is going to be facing new situations you never expected. You.ll be forced to patch the code (admit you're wrong) and then the code (wife) will just end up all bloated and unmaintainable in the end."
"Once upon a time there was a DOS user who saw Unix, and saw that it was good. After typing cp on his DOS machine at home, he downloaded GNU's unix tools ported to DOS and installed them. He rm'd, cp'd, and mv'd happily for many days, and upon finding elvis, he vi'd and was happy. After a long day at work (on a Unix box) he came home, started editing a file, and couldn't figure out why he couldn't suspend vi (w/ ctrl-z) to do a compile."
Terms of Use

Computer How To

How To, Tutorial, Example, Review

Setting the database engine type in MySQL

Be the first to comment

Leave a Reply Cancel reply