Mysqldump on both databases
Do a diff on both files
Redirect the output to a file
Mysql database < parse_file_to_sync
Easiest way, there are some other methods which basically do the same
thing.
-->-----Original Message-----
-->From: Nikos Gatsis [mailto:nikos@stripped]
-->Sent: Thursday, May 29, 2003 12:15 PM
-->To: mysql@stripped
-->Subject: compare db's
-->
-->GlacierHello list
-->
-->I have 2 mysql databases.
-->The first is on the internet (under RH linux 7,2).
-->The second is on a local network (under RH linux 7,2 also).
-->The two databases have some common tables and I wish to "compare"
them
-->and
-->"copy" the new record of the Internet tables to the local database.
-->
-->Any ideas how to do that;
-->I use mysql 3,23,33 and php 4,06
-->Thanx
-->Nikos
-->
-->
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/mysql?unsub=1
