Solved

how to change from default database engine MyISAM to InnoDB

Posted on 2015-01-04
2
333 Views
Last Modified: 2016-03-18
Dear Experts:

I have installed rhel6.6 and completed  installing the mysql55 packages now before installing the sugarcrm 7.5 would like to configure the mysql server to use InnoDB database engine. please let me know in which config file I have to enable the innoDB.
I would like to configure InnoDB as the default configuration before installing the sugarcrm , please suggest how to configure this. thanks in advance
0
Comment
Question by:D_wathi
2 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 300 total points
ID: 40530566
This article http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html says that InnoDB is the default starting with MySQL 5.5.  The last paragraph shows how to check the status.

Note however that 'create database' and 'create table' statements can select the database engine that they want and ignore the default.
0
 
LVL 77

Assisted Solution

by:arnold
arnold earned 200 total points
ID: 40530937
The .sql script creating the table should specify the engine=innodb  during the create database.
Within my.cnf you can set deafult engine as innodb.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question