Thursday, July 07, 2011
Preserving Relationship Diagram in MySQL after export
Discovered a smooth technique on preserving the relationship constraints when uncertain error occurs as one attempts to recreate a db into a new one via phpMyAdmin. First, attempt to to copy db via operations tab, Second, export structure only, then copy paste the whole constraint part, then run them against the new db, and viola! Hope this helps.