Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Programming/Scripts

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th November 2009, 08:55
Linusr@flanders Linusr@flanders is offline
Junior Member
 
Join Date: Dec 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL - a little help please

Hi,

I hope this is the right spot for this question, if not, sorry...

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 likely-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 how to and some examples?

Thanks!!

Thor
Reply With Quote
Sponsored Links
  #2  
Old 12th November 2009, 10:50
iInspire iInspire is offline
Junior Member
 
Join Date: Nov 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Im not sure with MySQL, but i think there ia way to do it in Oracle ...\\but not sure
Reply With Quote
  #3  
Old 30th November 2009, 05:05
btomasik btomasik is offline
Junior Member
 
Join Date: Nov 2009
Posts: 18
Thanks: 2
Thanked 0 Times in 0 Posts
 
Default

How about a cronjob bash script?
Reply With Quote
Reply

Bookmarks

Tags
confederated tables, linked tables, mysql, replication

Thread Tools
Display Modes

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add ons for ISPConfig 3 virtue Installation/Configuration 24 16th October 2009 18:30
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 02:05
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 01:44.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.