Solved

How to enable InnoDB support in  MySQL ?

Posted on 2010-11-19
4
754 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 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