[NCLUG] mysql: backing up database - cannot save relationships

[phil marsh]

Hi Stephen,
Some of the tables contain links to files on disk.
Relationships are database structures that link one table to another in the database. Say if one table contains a person's name, and another table in the database also contains the person's name with other columns containing personal information, a relationship will link the two columns containing the person's name in the two tables of the database. These above two structures are apparently not being saved in the export database backups I'm trying to make. My Google efforts have been fruitless and it's almost as if nobody else has seen this, so my error is likely obvious and/or simple but I just can't find it.
Thanks,
Phil




________________________________
 From: Stephen Warren <swarren at wwwdotorg.org>
To: Northern Colorado Linux Users Group <nclug at lists.nclug.org> 
Cc: phil marsh <montanaembassy at yahoo.com> 
Sent: Thursday, August 8, 2013 4:50 PM
Subject: Re: [NCLUG] mysql: backing up database - cannot save relationships
 

On 08/08/2013 03:59 PM, phil marsh wrote:
> Hi all,
> I was wondering if any of you saw this issue and could kindly give me your opinion?
> When I attempt to backup my mysql databases from phpmyadmin or mysql directly via export (SQL data) then import them, the imported database lacks the relationships and also the links.

What exactly are "relationships" and "links". Are they simply tables
that contain the keys of other tables? Do those tables appear in the
dump itself?