You may want to consider automating the synchronization of your databases
via replication. Check out the Replication chapter in the MySQL manual
(chapter 6 in the MySQL 5.0 manual).
I don't know if Replication can cope with changes to the table structure -
I've never played with Replication - but the manual should tell you whether
this is a problem or is handled well by MySQL.
--
Rhino
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Sunday, May 07, 2006 11:41 AM
Subject: How to synchronize two databases
Dear Friends,
I have two databases with the same name and table structure but the content
is different, I need to synchronize them i mean the data inside one database
need to be updated with the other one leaving the etries which are similar.
Let me give a single example:
DB1:table1
Rows like : userid name
Ist row 1 abhishek
IInd row 2 jain
III row 3 rahul
DB2:table1
Rows like : userid name
Ist row 1 abhishek
IInd row 2 amitabh
III row 3 vijay
Now i want like :
Rows like : userid name
Ist row 1 abhishek
IInd row 2 jain
III row 3 rahul
IV row 4 amitabh
V row 5 vijay
NOTE: Here DB1 = database names , table1 = table name .
How can i do that via mysql or that i need to prepare a script for this can
anyone help.
Regards,
Abhishek Jain
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 05/05/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 05/05/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]