Tuesday, April 27, 2010

How to set INNODB as your default engine in MYSQL?

Kathiravan Manoharan 3:41:00 PM mySQL , XAMPP No comments :

Problem:
The early version of MySQL is set with "myisam" as the default storage engine. How to set INNODB as your default engine?

Solution:

SET STORAGE_ENGINE = INNODB;

To set other engines as your default storage engine:

set storage_engine = InnoDB;
set storage_engine = MyISAM;
set storage_engine = Falcon;
set storage_engine = PBXT;
set storage_engine = Maria;

Steps:

1. Open your MySQL configuration file (Usually found in location, /etc/my.cnf).

2. Add "SET STORAGE_ENGINE=INNODB".

3. Save and Exit

Featured Blog Topics:

Forgot Drupal Login URL -http://kathyravan.blogspot.com/2009/08/forgot-drupal-login-url.html

Unset Drupal Clean URL Settings - http://kathyravan.blogspot.com/2009/08/how-to-unset-drupal-clean-url-settings.html

Joomla Updated Extensions List - http://kathyravan.blogspot.com/2009/08/joomla-updated-extentions-list.html