Why is InnoDB disabled? (SOLVED)
after installing Drupal 6 appliance i do have problem to enable InnoDB in MySQL.
can some one help me please?
Thx
after installing Drupal 6 appliance i do have problem to enable InnoDB in MySQL.
can some one help me please?
Thx
Innodb in enabled by default
If you log in to PhpMyAdmin and go to the "Storage Engines" section, you'll notice that InnoDB is not disabled.
See the MySQL manual for more information (13.2.3. InnoDB Configuration).
my.cnf
skip-innodbcommented out = enabled innodb in mysqld. I tried to run live system to see defaults and realised following:mysql> show engine innodb status;ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined
mysql>
thx in advance
I can't reproduce this...
If you want me to try and investigate/reproduce your problem you are going to have to give me a great deal more information:
* what version of the appliance are you using?
* are you using the appliance in live mode or installed to a hard drive?
* what kind of machine or virtual machine is running the appliance? how much memory does it have?
* did you reconfigure mysql in any way?
* could you try starting over and see what it takes to reproduce this problem?
demanded answers
turnkey-drupal6-2008.10.28-hardy-x86
Live mode. 8GB HDD ready but not used for installation
VM - VirtualBox-2.1.0-41146-Win_x86.msi
512 MB RAM
no reconfiguration
I did only following:
mysql -u root -p
inserted password
mysql> show engine innodb status;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because
skip-innodb is defined
mysql> show engines;
InnoDB |DISABLED
news
Your innodb log files were corrupt?
Thanks for sharing!
Thanks!
Thanks for the tip! This solved the problem for me also.
THANKS!
Thank you, Hoke!
I'm not even using Drupal, and the solution you provided has saved me! Seens like a bug with the log files!
Thank you, again!
CaioToOn!
setting InnoDB as default mysql storage engine
Thank you
I ran across this same problem w/ Joomal and your solution did the trick thanks so much!
This helped me, too!
Thanks so much for this information! I had the same problem here.
Thanks
This worked for me. One thing to note was that I had to add default-storage-engine=innodb directly below the commented skip-innodb statement. This is on CentOS 5.3.
I don't have "skip-innodb statement" in my.cnf
Hi there. I'm having trouble enabling InnoDB.
But I don't have "skip-innodb statement" in my.cnf! It's a very small file, only a few lines.
cat /etc/my.cnf
I already tryed removing files /var/lib/mysql/ib* and restarting mysqld, but the problem remains. I've updated mysql to the latest version using YUM (BTW, I'm using CentOS 5)
Anyone can help me? Thanks.
SOLVED
I solved my problem. It seem that is was a permission issue:
cat /var/log/mysqld.log
All I needed was a "chmod 777 /tmp" to get InnoDB working...
Thanks anyway
Innodb Issue
I am unable to enable the innod engines support in my server, skip-innodb is not mentioned in the my.cnf file but while I execute the show engines; syntax I am getting the below result which says that InnoDB is Diasabled.
mysql> show engines;
+------------+------------+----------------------------------------------------------------------------------+
| Engine | Support | Comment |
+------------+------------+----------------------------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys |
And when I run the query mysql> show engine innodb status; the result was "ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined" even the skip-innodb was not mentioend in the cnf.
Skip-innodb was not mentioned in the my.cnf file by while I execute the show engine innodb status; I am getting the below result which says " Cannot call SHOW INNODB STATUS because skip-innodb is defined".
mysql> show engine innodb status;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined
Post new comment