innodb

  1. Z

    Roundcube database Unknown storage engine 'InnoDB'

    Hi, We receive notice from cpanel as below: check_mysql has determined that there are corrupted database tables cPanel & WHM has determined that the following database tables are corrupt: Database Error roundcube roundcube.cache Error : Unknown storage engine 'InnoDB' error : Corrupt...
  2. N

    How to force mysql v.5.5.32 to create MyISAM tables instead of InnoDB?

    I have upgraded to this latest version of MySQL 5.5.32, but it standard creates InnoDB based tables and to be compatible with some software I run I would like it to create a new DB with MyISAM tables. How to do this?
  3. M

    The InnoDB memory heap is disabled

    hello i see below in this directory: "/var/lib/mysql/host.mysite.com.err" how i can resolve them? means how i can enable them? Thanks! - - - Updated - - - also i see below Please explain about each them.
  4. C

    Magento Installation - Database server does not support the InnoDB storage engine

    Hi, Im having difficulty with the installation of Magento. On the configuration page I am presented with the error message: "Database server does not support the InnoDB storage engine" Im installing Magento using cPanel on a shared host. Does anyone have any idea how to solve this issue. Thanks
  5. konrath

    ibdata1 is very large. How to return the tables from innodb to mysql ?

    Hello My ibdata1 is very large and eat all memory. :( How to return the tables from innodb to mysql ? Any suggestion? Steps ? Thank you Marcelo Konrath
  6. T

    innoDB tables corrupt, mySQL failing to restart

    Good Afternoon, I have tried to contact support to fix the issue I am having, but they have suggested to get a DBA to fix the issues I'm having. While, in a perfect world I would be more than willing to do this, I don't have access to the cash in order to do it. While DB's are something...
  7. S

    InnoDB: Have you moved InnoDB .ibd files - Error

    Hello, Mysql error logs shows - InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. InnoDB...
  8. A

    Is my command for backup the same as know i am using Innodb?

    Is my command for backup the same as now i am using Innodb? Hello All my tables was Myisam and i was use this command for backup: /scripts/pkgacct account1 and i got a working backup about 820MB. After 2-3 i convert many (not all) of my tables to Innodb and i want to ask if i must...
  9. A

    Installing innodb on an existing server

    Howdy. I was wondering if anyone could shed some light on this for me. Have you installed innodb or do you know if installing innodb on a server that already has customer sites on it will cause an derogatory effects on those account? IE can I expect customer databases to be corrupted or...
  10. Y

    MySQL 5.1.40 InnoDB

    Linux version: CentOS release 5.4 (final) cPanel version: cPanel 11.25.0-E42048 - WHM 11.25.0 - X 3.9 MySQL version: 5.1.40 Seems like MySQL 5.1.40 lacks InnoDB. I just noticed after running /script/cpbackup and looking at the log files noticing Grabbing mysql dbs........carpetc1_wrdp17...
  11. E

    Should I enable InnoDB?

    Hello, I have a customer complaining that InnoDB isn't enabled. After reading some threads on this forum, (and over some external forums), i realized that innodb isn't a good idea for a shared enviroment. My main concern is about a few users eating most of the server resources. After...
  12. S

    pkgacct2 and problem with InnoDB tables

    Hi, I was transferring a cPanel account from one server to another today using the pkgacct2 script. Everything went well, but when I checked the database of the user in phpMyAdmin after restoring the account on the new server, all the InnoDB tables were missing. The MyISAM tables shows up...
  13. M

    Magento needs InnoDB - is that compatible with other apps?

    Hi, A client needs to install Magento Ecommerce http://www.magentocommerce.com/system-requirements But getting this error: "Database server does not support InnoDB storage engine". We currently have MySQL version 4.1.22-standard-log PHP version 5.2.8 1. Cann MySQL 4.1.22 support...
  14. K

    innoDB not enabled by default?

    Hi there -- I'm quite new to all of this so sorry if this is a "dumb question" ... I am not doing great at moving my old phpbb database to my new server, and I"m thinking of trying to use InnoDB storage engine rather than MyISAM which is the default on my new WHM/Cpanel server. In...
  15. S

    innodb removed mysql storage type

    So I don't know when this happened, but sometime in the past year innodb was removed as a storage type selection from mysql. I checked the my.cnf and skip-innodb was in there, so I then commented it out and restarted mysql, but it fails to start. I'm running the following versions of whm...
  16. cPanelNick

    How to enable INNODB to work with mysql 5.xx?

    Just remove any disable options for innodb in /etc/my.cnf (and restart mysql)
  17. B

    Change database from myisam to innodb

    How to change database from myisam to innodb, I just want the database, tables are already changed. (MySQL 5.0)
  18. S

    cpanel, innodb and backups - is it supported?

    does cpanel properly backup innodb mysql databases? does it run a mysqldump against the db if it does? i read it's not supported ... is it?
  19. R

    Enable InnoDB?

    Is it possible to enable InnoDB on my VPS from the root version of WHM?
  20. G

    how to allow innoDB for client?

    Hi guys, how do i allow innoDB for client in mysql?