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: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]