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:[EMAIL PROTECTED] -->Sent: Thursday, May 29, 2003 12:15 PM -->To: [EMAIL PROTECTED] -->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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]