I´m not so sure about that, but I think in MySql 3.23 the InnoDB engine was disabled by default so you must be almost a PhD to enable it.
What about updating server? -- João Cândido de Souza Neto ""M. Rodrigo Monteiro"" <fale...@rodrigomonteiro.net> escreveu na mensagem news:AANLkTimPVMS_e3dQyHS=bRyOy5WYp78hYhv6mN=2b...@mail.gmail.com... On Mon, Jan 31, 2011 at 09:39, Reindl Harald <h.rei...@thelounge.net> wrote: > seems there is "skip-innodb" in your configuration > what do "show engines;" say? In my.cnf (comment) #skip-innodb mysql> show engines; +------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+----------------------------------------------------------------+--------------+------+------------+ | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | +------------+---------+----------------------------------------------------------------+--------------+------+------------+ So, I don't have support for InnoDB. :( # cat /etc/redhat-release CentOS release 5.5 (Final) # rpm -qa | grep -i mysql php-mysql-5.1.6-27.el5 MySQL-server-community-5.1.50-1.rhel5 MySQL-devel-community-5.1.50-1.rhel5 MySQL-client-community-5.1.50-1.rhel4 So, why InnoDB is not supported? Regards, Rodrigo. > > i would recommend "sql-mode = STRICT_ALL_TABLES" in /etc/my.cnf > where ever no dirty applications are running which depends > on the bad standard behavior silently ignore errors > > -- > > Mit besten Grüßen, Reindl Harald > the lounge interactive design GmbH > A-1060 Vienna, Hofmühlgasse 17 > CTO / software-development / cms-solutions > p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 > icq: 154546673, http://www.thelounge.net/ > > -- M. Rodrigo Monteiro "Free as in Freedom, not free as in free beer" "As we are liberated from our own fear, our presence automatically liberates others" Linux User # 403730 Pense antes de imprimir. Think before printing. AVISO LEGAL Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação confidencial e/ou legalmente privilegiada. Se você não for destinatário desta mensagem, desde já fica notificado de abster-se a divulgar, copiar, distribuir, examinar ou, de qualquer forma, utilizar a informação contida nesta mensagem, por ser ilegal. Caso você tenha recebido esta mensagem por engano, pedimos que nos retorne este E-Mail, promovendo, desde logo, a eliminação do seu conteúdo em sua base de dados, registros ou sistema de controle. Fica desprovida de eficácia e validade a mensagem que contiver vÃnculos obrigacionais, expedida por quem não detenha poderes de representação. LEGAL ADVICE This message is exclusively destined for the people to whom it is directed, and it can bear private and/or legally exceptional information. If you are not addressee of this message, since now you are advised to not release, copy, distribute, check or, otherwise, use the information contained in this message, because it is illegal. If you received this message by mistake, we ask you to return this email, making possible, as soon as possible, the elimination of its contents of your database, registrations or controls system. The message that bears any mandatory links, issued by someone who has no representation powers, shall be null or void. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
