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

[Brian Grossman]

So your link tables are missing?  (http://en.wikipedia.org/wiki/Junction_table)

Or do you mean foreign keys? (http://en.wikipedia.org/wiki/Foreign_key)

Does it work if you use mysqldump directly?  If not, what options did you use?

Brian

On Thu, 8 Aug 2013 16:01:07 -0700 (PDT)
phil marsh <montanaembassy at yahoo.com> wrote:

> 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?
> _______________________________________________
> NCLUG mailing list       NCLUG at lists.nclug.org
> 
> To unsubscribe, subscribe, or modify
> your settings, go to:
> http://lists.nclug.org/mailman/listinfo/nclug