Solved

How to enable InnoDB support in  MySQL ?

Posted on 2010-11-19
4
758 Views
Last Modified: 2012-06-27
Just installed the latest verson of MYSQL Server.  It will not start with INNODB enabled.  I need INNODB support.  I need to ENABLE it.  It is NOT Disabled in the ini file.  However, to start mysql, I need to disable it in the ini file.

The HAVE_INNODB Variable in the info-schemo database is set to NO.  I can't change this to YES.  Could this be the problem?  How do I change it ?
0
Comment
Question by:pvg13
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:ushastry
ID: 34173411
Hi,

Could you post the recent error log contents???

Also, comment out if there is any skip-innodb line from the config file and make sure below line exists in the config file.. change the path "/path/to/mysql/data/" to exact path in below section.. once you ensured that below line exists then restart MySQL and confirm from show engines/ have% etc

innodb_data_home_dir = /path/to/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /path/to/mysql/data/
innodb_log_arch_dir = /path/to/mysql/data/

innodb_buffer_pool_size=16M
innodb_additional_mem_pool_size=2M

innodb_log_file_size=5M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50
0
 

Accepted Solution

by:
pvg13 earned 0 total points
ID: 34175389
Found the solution.

Stop Mysql Service.

Go into mysql data directory.

Locate the ib*.* files

Make a backup of the ib*.* files

Delete ib*.* files

Start Mysql Server

It recreates the files and everything is running fine!

-Pete
0
 
LVL 26

Expert Comment

by:ushastry
ID: 34178619
Is it new instance or copied from other box? pls confirm
0
 

Author Closing Comment

by:pvg13
ID: 34203817
Tried multitude of options and this solution was the only one that worked.
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 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