For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > November 2004 > ANN: MySQLDiff 0.1, program to output diffs between MySQL tables









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ANN: MySQLDiff 0.1, program to output diffs between MySQL tables
Rajesh Kumar

2004-11-20, 8:55 pm

Hello PHP Community,

MySQLDiff is a PHP5 command-line utility that prints SQL statements to
sync two MySQL databases or tables.

This program works just like the original MySQLDiff
(http://www.mysqldiff.org/), but is much faster and is useful for
quickly comparing two databases.

The source code may be obtained from a public Subversion repository, and
tested as shown:

$ svn co http://www.svnhosting.org:8000/svn/mysqldiff/trunk mysqldiff
$ cd mysqldiff
$ sudo make install
.. installs to /usr/local/bin/mysqldiff
$ mysqldiff db1 db2
$ mysqldiff --paranoid db1.tbl db2.tbl

MySQLdiff is still alpha and requires heavy testing and
improvements. All required PEAR packages are packaged with MySQLDiff.
Copyrights may have been violated with regards to PEAR::Text_Diff. If
so, I'm prepared to take necessary action.

Please contact me (off-list) if you're interested in becoming a
developer. Please send patches against the HEAD revision by executing
`svn up && svn diff'

Bug reports, feature suggestions and help requests welcome.

--
Rajesh Kumar
MySQLDiff Maintainer
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com