List:General Discussion« Previous MessageNext Message »
From:M. Rodrigo Monteiro Date:January 31 2011 12:52pm
Subject:Re: Table creation
View as plain text  
On Mon, Jan 31, 2011 at 09:39, Reindl Harald <h.reindl@stripped> 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.
Thread
Table creationM. Rodrigo Monteiro31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationM. Rodrigo Monteiro31 Jan
      • Re: Table creationRodrigo Ferreira31 Jan
      • Re: Table creationReindl Harald31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationAnanda Kumar31 Jan
  • Re: Table creationReindl Harald31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationM. Rodrigo Monteiro31 Jan
      • Re: Table creationpetya31 Jan
Re: Table creationM. Rodrigo Monteiro31 Jan