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

[phil marsh]

Incidently, I've been using the MyISAM storage engine. I also tried InnoDB but with no difference in results. 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?