From: Dyego Pessoal
Date: February 3 2006 7:46pm
Subject: MySQL 5.0 probleam with show table status
List-Archive: http://lists.mysql.com/mysql/194580
Message-Id: <43E3B2FF.3060907@escriba.com.br>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I have a serius probleam , my backup system see the FK's with "show 
table status like 'tablename'" , and read the Comment column...
in mysql 4.x works fine... but em 5.x the FK's has cuted....

ex:
| apresentante | InnoDB |       9 | Redundant  |   44 |            372 
|       1
6384 |               0 |        81920 |         0 |             50 | 
2005-08-04
11:19:15 | NULL        | NULL       | latin1_swedish_ci |     NULL |
    | InnoDB free: 111101952 kB; (`Ap_UsuarioAlteracao`) REFER 
`sqlreg3/usuario`
(`Us_I | <--- ********* HERE IS THE PROBLEM !!!!!!!! ******


But , the "show create table command" shows:

| apresentante |CREATE TABLE `apresentante` (
  `Ap_Id` int(4) unsigned NOT NULL auto_increment,
  `Ap_Nome` varchar(200) NOT NULL default '',
  `Ap_Endereco` varchar(200) NOT NULL default '',
  `Ap_Telefone` varchar(30) NOT NULL default '',
  `Ap_EMail` varchar(200) NOT NULL default '',
  `Ap_DataInclusao` date NOT NULL default '0000-00-00',
  `Ap_HoraInclusao` time NOT NULL default '00:00:00',
  `Ap_DataAlteracao` date NOT NULL default '0000-00-00',
  `Ap_HoraAlteracao` time NOT NULL default '00:00:00',
  `Ap_UsuarioInclusao` int(4) unsigned default NULL,
  `Ap_UsuarioAlteracao` int(4) unsigned default NULL,
  UNIQUE KEY `Ap_Id` (`Ap_Id`),
  KEY `IAp_Nome` (`Ap_Nome`),
  KEY `iAp_UsDtHoInclusao` (`Ap_DataInclusao`,`Ap_HoraInclusao`),
  KEY `iAp_UsDtHoAlteracao` (`Ap_DataAlteracao`,`Ap_HoraAlteracao`),
  KEY `iap_UsuarioInclusao` (`Ap_UsuarioInclusao`),
  KEY `iap_UsuarioAlteracao` (`Ap_UsuarioAlteracao`),
  CONSTRAINT `apresentante_ibfk_1` FOREIGN KEY (`Ap_UsuarioAlteracao`) 
REFERENCE
S `usuario` (`Us_Id`),
  CONSTRAINT `apresentante_ibfk_2` FOREIGN KEY (`Ap_UsuarioInclusao`) 
REFERENCES
 `usuario` (`Us_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |




I'm using MySQL 5.0.18-PRO on Linux Debian Box with kernel 
2.6.14-2-686-smp on Xeon 2.4 machine with 1GB of RAM

Using InnoDB tables...


Tnks in advance....

Innodb,MySQL,user,heeeelllppp


-- 



-------------------------------------------------------------------------
++  Dyego Souza Dantas Leal   ++           Dep. Desenvolvimento   -------------------------------------------------------------------------
               E S C R I B A   I N F O R M A T I C A
        ***        http://javacoffe.blogspot.com        ***
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--                                        ICQ   : 1647350
$ look into "my eyes"                     Phone : +55 041 2106-1212    

look: cannot open my eyes                 Fax   : +55 041 3296-6640     -------------------------------------------------------------------------
             Reply: dyego@stripped