Hi, > 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....
This didn't work "fine" in 4.x at all. The "comments" columns was being misused to report FKs. Even more: it was being mis-used AND it was unreliable. > 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: --8<-- snip > 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 | > This is is the only way to get the FK data. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
