List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:February 3 2006 8:00pm
Subject:Re: MySQL 5.0 probleam with show table status
View as plain text  
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

Thread
MySQL 5.0 probleam with show table statusDyego Pessoal3 Feb
  • Re: MySQL 5.0 probleam with show table statusMartijn Tonies3 Feb