#3447 Relations (foreign key) lost on export

Latest_Git_snapshot
fixed
5
2013-06-11
2011-10-04
No

See bug : #3418311, I have the same problem, but in the Git (20111004-022002), not in 3.4.5

On older versions of phpMyAdmin (including 3.4.5), at the end of the SQL dump, it adds the alter table to add the foreign keys, like so :

ALTER TABLE `usersPermissions`
ADD CONSTRAINT `usersPermissions_ibfk_2` FOREIGN KEY (`user`) REFERENCES `users` (`identifier`) ON DELETE CASCADE,
ADD CONSTRAINT `usersPermissions_ibfk_3` FOREIGN KEY (`permission`) REFERENCES `permissions` (`identifier`) ON DELETE CASCADE;

I have found that in the few latest Git snapshot, the export doesn't export the foreign keys anymore. I have tested with different tables/schemas.

Discussion

  • Marc Delisle

    Marc Delisle - 2011-11-12
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2011-11-12

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2011-11-12
    • status: open --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed