Cai Black

If you were to log in, you'd be able to get more information on your fellow community member.

Static Page Comments

• June 9, 2011, on Introduction to Database Management Systems:

  The default storage engine can be changed in the MySQL config file, which on Linux (e.g. RHEL, CentOS, Debian, SLES, etc.) is stored at /etc/my.cnf

  Within that file there SHOULD be a section labeled [mysqld]. Add the following line immediately below that label so that the result is as follows:

  [mysqld]

  default-storage-engine = myisam

  You will then need to restart the mysqld process. There are different ways to accomplish this task depending upon your version of Linux. One way is as follow:

  <...

  ---

  philg@mit.edu

  /etc/init.d/mysql stop