Table creation

Hi!

I'm trying to create a InnoDB table.

CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) TYPE=3DInnoDB;

show table status from DATABASE like 'Teste2';

+--------+--------+---------+------------+------+----------- -----+---------=
----+-----------------+--------------+-----------+---------- ------+--------=
-------------+---------------------+------------+----------- --------+------=
----+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time | Update_time |
Check_time | Collation | Checksum | Create_options | Comment |
+--------+--------+---------+------------+------+----------- -----+---------=
----+-----------------+--------------+-----------+---------- ------+--------=
-------------+---------------------+------------+----------- --------+------=
----+----------------+---------+
| Teste2 | MyISAM | 10 | Dynamic | 0 | 0 |
0 | 281474976710655 | 1024 | 0 | NULL
| 2011-01-31 08:53:49 | 2011-01-31 08:53:49 | NULL |
latin1_swedish_ci | NULL | | |
+--------+--------+---------+------------+------+----------- -----+---------=
----+-----------------+--------------+-----------+---------- ------+--------=
-------------+---------------------+------------+----------- --------+------=
----+----------------+---------+

As you can see, the table creates in MyISAM type.
What's going on?

Regards,
Rodrigo.


--=20
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 =E9 destinada exclusivamente para a(s) pessoa(s) a quem =E9
dirigida, podendo conter informação confidencial e/ou legalmente
privilegiada. Se voc=EA n=E3o for destinat=E1rio desta mensagem, desde j=E1
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=EA tenha recebido esta mensagem por engano,
pedimos que nos retorne este E-Mail, promovendo, desde logo, a
eliminação do seu conte=FAdo em sua base de dados, registros ou sistema
de controle. Fica desprovida de efic=E1cia e validade a mensagem que
contiver v=EDnculos obrigacionais, expedida por quem n=E3o 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Table creation

CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) ENGINE=InnoDB;


--
João Cândido de Souza Neto

""M. Rodrigo Monteiro"" escreveu na mensagem
news:AANLkTikv4dtLTh+BMqxCwcCw5K59PU5W=ZrT3j3tH1Ew@mail.gmai l.com...
Hi!

I'm trying to create a InnoDB table.

CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
VARCHAR(10)) TYPE=InnoDB;

show table status from DATABASE like 'Teste2';

+--------+--------+---------+------------+------+----------- -----+-------------+-----------------+--------------+------- ----+----------------+---------------------+---------------- -----+------------+-------------------+----------+---------- ------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time | Update_time |
Check_time | Collation | Checksum | Create_options | Comment |
+--------+--------+---------+------------+------+----------- -----+-------------+-----------------+--------------+------- ----+----------------+---------------------+---------------- -----+------------+-------------------+----------+---------- ------+---------+
| Teste2 | MyISAM | 10 | Dynamic | 0 | 0 |
0 | 281474976710655 | 1024 | 0 | NULL
| 2011-01-31 08:53:49 | 2011-01-31 08:53:49 | NULL |
latin1_swedish_ci | NULL | | |
+--------+--------+---------+------------+------+----------- -----+-------------+-----------------+--------------+------- ----+----------------+---------------------+---------------- -----+------------+-------------------+----------+---------- ------+---------+

As you can see, the table creates in MyISAM type.
What's going on?

Regards,
Rodrigo.


--
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=gcdmg-mysql-2@m.gmane.org

Re: Table creation

Hi!

2011/1/31 Jo=E3o C=E2ndido de Souza Neto :
> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
> VARCHAR(10)) ENGINE=3DInnoDB;
>

I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.


Regards,
Rodrigo.

--=20
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 =E9 destinada exclusivamente para a(s) pessoa(s) a quem =E9
dirigida, podendo conter informação confidencial e/ou legalmente
privilegiada. Se voc=EA n=E3o for destinat=E1rio desta mensagem, desde j=E1
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=EA tenha recebido esta mensagem por engano,
pedimos que nos retorne este E-Mail, promovendo, desde logo, a
eliminação do seu conte=FAdo em sua base de dados, registros ou sistema
de controle. Fica desprovida de efic=E1cia e validade a mensagem que
contiver v=EDnculos obrigacionais, expedida por quem n=E3o 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Table creation

--------------enig9E5A2D231F7A56CBAFA8EA48
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

'TYPE' is deprecated since long time ago and should be
replaced everywhere with 'ENGINE'

with mysql 5.5 'TYPE' is a hard error which can be problematic
if running statement-based replication with a 5.1 master
and 5.5 slave because the master writes the statement to
binlog and slave will stop replication after that

Am 31.01.2011 13:16, schrieb M. Rodrigo Monteiro:
> Hi!
>=20
> I'm trying to create a InnoDB table.
>=20
> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
> VARCHAR(10)) TYPE=3DInnoDB;
>=20
> show table status from DATABASE like 'Teste2';
>=20
> +--------+--------+---------+------------+------+----------- -----+-----=
--------+-----------------+--------------+-----------+------ ----------+--=
-------------------+---------------------+------------+----- -------------=
-+----------+----------------+---------+
> | Name | Engine | Version | Row_format | Rows | Avg_row_length |
> Data_length | Max_data_length | Index_length | Data_free |
> Auto_increment | Create_time | Update_time |
> Check_time | Collation | Checksum | Create_options | Comment |
> +--------+--------+---------+------------+------+----------- -----+-----=
--------+-----------------+--------------+-----------+------ ----------+--=
-------------------+---------------------+------------+----- -------------=
-+----------+----------------+---------+
> | Teste2 | MyISAM | 10 | Dynamic | 0 | 0 |
> 0 | 281474976710655 | 1024 | 0 | NULL
> | 2011-01-31 08:53:49 | 2011-01-31 08:53:49 | NULL |
> latin1_swedish_ci | NULL | | |
> +--------+--------+---------+------------+------+----------- -----+-----=
--------+-----------------+--------------+-----------+------ ----------+--=
-------------------+---------------------+------------+----- -------------=
-+----------+----------------+---------+
>=20
> As you can see, the table creates in MyISAM type.
> What's going on?

--=20

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/


--------------enig9E5A2D231F7A56CBAFA8EA48
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk1GrOAACgkQhmBjz394AnlcXwCeOqGO8OewI7i5VsoCC/Lr 0S72
C3sAn14eH1nCz0uZLRv++W8Sj9IgtFi4
=10NS
-----END PGP SIGNATURE-----

--------------enig9E5A2D231F7A56CBAFA8EA48--

Re: Table creation

--------------enig9822644905FD0FB8F0C9A2CC
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable


Am 31.01.2011 13:34, schrieb M. Rodrigo Monteiro:

> 2011/1/31 Jo=E3o C=E2ndido de Souza Neto :
>> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
>> VARCHAR(10)) ENGINE=3DInnoDB;
>>
>=20
> I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething=


seems there is "skip-innodb" in your configuration
what do "show engines;" say?

i would recommend "sql-mode =3D STRICT_ALL_TABLES" in /etc/my.cnf
where ever no dirty applications are running which depends
on the bad standard behavior silently ignore errors

--=20

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/


--------------enig9822644905FD0FB8F0C9A2CC
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk1GrYMACgkQhmBjz394Anlb/gCfbOUQ5idjoDJl/Bm3exOV ibGK
MqEAoI30O75oJNv/e4IVBsTDt/lpkIBQ
=fuPk
-----END PGP SIGNATURE-----

--------------enig9822644905FD0FB8F0C9A2CC--

Re: Table creation

Please, give us some information about your server.

--
João Cândido de Souza Neto

""M. Rodrigo Monteiro"" escreveu na mensagem
news:AANLkTikw2rDzhZU2+SmVeiPnVCYB-Q=Vce5NUfA7OEVP@mail.gmai l.com...
Hi!

2011/1/31 João Cândido de Souza Neto :
> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
> VARCHAR(10)) ENGINE=InnoDB;
>

I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.


Regards,
Rodrigo.

--
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=gcdmg-mysql-2@m.gmane.org

Re: Table creation

--00163683397a59a54d049b23e24e
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

what does 'show create table teste2" shows

2011/1/31 Jo=E3o C=E2ndido de Souza Neto

> Please, give us some information about your server.
>
> --
> Jo=E3o C=E2ndido de Souza Neto
>
> ""M. Rodrigo Monteiro"" escreveu na mensage=
m
> news:AANLkTikw2rDzhZU2+SmVeiPnVCYB-Q=3DVce5NUfA7OEVP@mail.gm ail.com...
> Hi!
>
> 2011/1/31 Jo=E3o C=E2ndido de Souza Neto :
> > CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
> > VARCHAR(10)) ENGINE=3DInnoDB;
> >
>
> I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.
>
>
> Regards,
> Rodrigo.
>
> --
> 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 =E9 destinada exclusivamente para a(s) pessoa(s) a quem =E9
> dirigida, podendo conter informação confidencial e/ou legalmente
> privilegiada. Se voc=EA n=E3o for destinat=E1rio desta mensagem, desde j=
=E1
> 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=EA tenha recebido esta mensagem por engano,
> pedimos que nos retorne este E-Mail, promovendo, desde logo, a
> eliminação do seu conte=FAdo em sua base de dados, registros ou siste=
ma
> de controle. Fica desprovida de efic=E1cia e validade a mensagem que
> contiver v=EDnculos obrigacionais, expedida por quem n=E3o detenha podere=
s
> 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=3Danandkl@gmail.com
>
>

--00163683397a59a54d049b23e24e--

Re: Table creation

On Mon, Jan 31, 2011 at 09:39, Reindl Harald 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 =3D 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/
>
>



--=20
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 =E9 destinada exclusivamente para a(s) pessoa(s) a quem =E9
dirigida, podendo conter informação confidencial e/ou legalmente
privilegiada. Se voc=EA n=E3o for destinat=E1rio desta mensagem, desde j=E1
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=EA tenha recebido esta mensagem por engano,
pedimos que nos retorne este E-Mail, promovendo, desde logo, a
eliminação do seu conte=FAdo em sua base de dados, registros ou sistema
de controle. Fica desprovida de efic=E1cia e validade a mensagem que
contiver v=EDnculos obrigacionais, expedida por quem n=E3o 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Table creation

--0-2090313188-1296478371=:82929
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Monteiro,

Probably, InnoDB in not enabled by default on your MySQL server.

I guess the statement "show engines" can help you.

Please, strip "LEGAL ADVICE" from your subsequent messages to the list.

Thanks,

Rodrigo Ferreira
CMDEV, CMDBA, Msc.

--- On Mon, 1/31/11, M. Rodrigo Monteiro wrot=
e:

From: M. Rodrigo Monteiro
Subject: Re: Table creation
To: mysql@lists.mysql.com
Date: Monday, January 31, 2011, 10:34 AM

Hi!

2011/1/31 Jo=E3o C=E2ndido de Souza Neto :
> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
> VARCHAR(10)) ENGINE=3DInnoDB;
>

I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.


Regards,
Rodrigo.

--=20
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 =E9 destinada exclusivamente para a(s) pessoa(s) a quem =E9
dirigida, podendo conter informação confidencial e/ou legalmente
privilegiada. Se voc=EA n=E3o for destinat=E1rio desta mensagem, desde j=E1
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=EA tenha recebido esta mensagem por engano,
pedimos que nos retorne este E-Mail, promovendo, desde logo, a
eliminação do seu conte=FAdo em sua base de dados, registros ou sistema
de controle. Fica desprovida de efic=E1cia e validade a mensagem que
contiver v=EDnculos obrigacionais, expedida por quem n=E3o 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:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Drodrigof_silva@=
yahoo.com

=0A
--0-2090313188-1296478371=:82929--

Re: Table creation

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"" escreveu na mensagem
news:AANLkTimPVMS_e3dQyHS=bRyOy5WYp78hYhv6mN=2B-Dy@mail.gmai l.com...
On Mon, Jan 31, 2011 at 09:39, Reindl Harald 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=gcdmg-mysql-2@m.gmane.org

Re: Table creation

2011/1/31 Jo=E3o C=E2ndido de Souza Neto :
> I=B4m 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.

But the version of MySQL is 5.1 as you can see below...

>
> What about updating server?
>
> # 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
>

Regards,
Rodrigo.

--=20
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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Table creation

Hi,

You should check your error logs for innodb errors, there will be the
key to the solution. If you want to avoid this behaviour, you can set
innodb=force in your configuration file to make innodb error fatal, or
set sql_mode to 'NO_ENGINE_SUBSTITUTION'.

Peter Boros

On 01/31/2011 08:21 PM, M. Rodrigo Monteiro wrote:
> 2011/1/31 João Cândido de Souza Neto:
>> 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.
>
> But the version of MySQL is 5.1 as you can see below...
>
>>
>> What about updating server?
>>
>> # 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
>>
>
> Regards,
> Rodrigo.
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org