Pete Thanks for responding. Correct I am not in a position to change the databases or the applications. The data is updated regularly. There should be no difference in the data, both applications must have exactly the same customer details.
Charlie -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Pete Sent: 08 November 2005 22:05 To: [email protected] Subject: Re: [php_mysql] Keeping different databases synchronised in MySQL4 In message <[EMAIL PROTECTED]>, Charlie Markwick <[EMAIL PROTECTED]> writes >Thanks but this doesn't help I have no choice to run these two applications. >I would prefer it if someone could help with the question in hand:- > >Is it possible to create a means by which these two table populate each >other. > >Charlie None of the suggestions that I have seen so far imply that you shouldn't run the two applications. Firstly, there is no "magic switch" to keep two different but similar tables in different databases in synch. I think that you said earlier that you couldn't change the databases or the applications. Is that correct? You want a third application? And how often is the customer data updated? If Application 1 and Application 2 hold differing information (client has different street address in the two tables, for example), then which data should be used? > >-----Original Message----- >From: [email protected] [mailto:[EMAIL PROTECTED] On >Behalf Of Jay Horvitz >Sent: 08 November 2005 17:05 >To: [email protected] >Subject: Re: [php_mysql] Keeping different databases synchronised in >MySQL4 > >What I would do if you wanted just one database for your customers, use >seperate IDs for each application...app1 uses cust_id1 and app2 uses >cust_id2 or something like that > > >Pete <[EMAIL PROTECTED]> wrote: >In message <[EMAIL PROTECTED]>, Charlie >Markwick <[EMAIL PROTECTED]> writes >>I am a relative newcomer to MySql and to be honest any sort of >>Database admin. >> >>I have two separate applications that use their own databases. Each >>have a table called Customer. The fields in each table are different >>but contain similar data. >> >>The data held in each of these tables is for an identical customer >>group. It is time consuming to enter the data twice. Is there any way >>I can get these different tables to update each other automatically >>perhaps by using a third intermediate table/database? >> >>Charlie > >Could you use ONE table for customers? MySQL databases on the same >server should have no problems about seeing each other. > >-- >Pete Clark > -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
