Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 11-06-2009, 01:34 AM   #1
Senior Member
Registered: Nov 2007
Location: Somewhere on my hard drive...
Distribution: Manjaro
Posts: 2,475
Blog Entries: 23

Rep: Reputation: 346Reputation: 346Reputation: 346Reputation: 346
Question MySQL - Confederated tables -How?


My project uses mySQL, of course. There are several databases in the system, each has a members table that is identical to the ones in the others. Members are checked as active of non-active (money). Now, opposed to editing every members table in every database, I'd like to adopt the following approach: house the members table in a separate database, edit that and have the update "seep" through to the databases, a likley-like the "other" db server where you'd link tables between databases. I heard the term "confederated" tables.

Any ideas where to get info, some howto and some examples?


Old 11-06-2009, 02:30 AM   #2
Registered: Sep 2009
Location: Northern California
Distribution: Ubuntu Debian CentOS RHEL Suse
Posts: 164

Rep: Reputation: 44
Would you *NEED* to have updates "seep through" to other tables?

Authentication, authorization and account capabilities are really something you can pull from the user database. You want, perhaps, a hash of "capabilities" which can be used when parsing requests by the user for services....does the hash match the requirement for access to useful functionality.

Is that what you're looking for? If so, you only need a query to update the users' access limits and a query to retrieve the authorization and compare it to the current request for service.
Old 11-06-2009, 03:02 AM   #3
Senior Member
Registered: Nov 2007
Location: Somewhere on my hard drive...
Distribution: Manjaro
Posts: 2,475
Blog Entries: 23

Original Poster
Rep: Reputation: 346Reputation: 346Reputation: 346Reputation: 346

Thanks for the reply...the members, though, are not related to the database users. They'd be members of an archery club. Points collected in competitions and so would be kept in that table.

The MySQL user would be the site itself, the PHP logs in via a password.

So, getting the userdata is not what I'm after. Sorry...


Last edited by Thor_2.0; 11-06-2009 at 03:02 AM. Reason: Typos, soooo many typos...


links, replication, tables

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql query two tables please Help Mike1569 Linux - Server 2 07-09-2009 01:31 AM
mysql reinstallation distorted by previous tables in /var/mysql mad4linux Linux - Software 0 10-04-2005 02:39 PM
MySQL tables from 4.0 to 3.0 michaelbhahn Linux - Software 0 08-31-2004 11:23 AM
mysql tables with a - pk21 Linux - Software 7 05-23-2003 07:27 AM
mysql tables noord28 Linux - Newbie 0 02-20-2003 03:56 AM

All times are GMT -5. The time now is 06:52 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration