Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Question Unanswered: Distributed Database

    I am using the MySql in Wondow 2000 platform and I want to do the following tasks, but havn't any idea to do at MySql. Can any help me ?

    Database 1: have 'Client' Table
    Database 2: Have 'Bussiness1' Table
    Database 3: have 'Bussiness2' Table

    I want to map the 'Client' table from Database 1 to others, such that in Database 2 & Database 2 have the 'Client' table and synchronsize to others. How Can I do?

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Re: Distributed Database

    dont know if suitable in ya case, my idea is to copy structure of 'Client' table to database 2 and 3, then write a sql statement file and a batch file that is run automatically by a scheduler every 1, 2 or 5 minutes (depends on how often you want) on the computer mysql resides.

    hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •