Projects / mysqldiff

mysqldiff

mysqldiff is a Perl script which compares the data structures (i.e. table definitions) of two MySQL databases and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch). Database structures can be compared whether they are files containing table definitions or existing databases, local or remote.

Tags
Licenses
Operating Systems
Implementation

Recent releases

  •  05 Oct 2011 23:45

    Release Notes: This release includes many bugfixes, new documentation, and a fairly complete test suite.

    •  20 Jun 2002 14:05

      Release Notes: The new '--' Postgres style comments are now supported. The Perl dependency was updated to 5.6.0. Other minor tweaks were made.

      •  24 Feb 2002 13:35

        Release Notes: Various bugfixes were made. Two new options which enable easy upgrading of table structures during the development process were added.

        •  08 Nov 2001 04:14

          Release Notes: Support for connections to mysqld via UNIX sockets.

          •  07 Nov 2001 19:16

            Release Notes: Splitting into multiple files, allowing use as a library or via the commandline, a new install procedure and minimal docs, support for table options, and minor bugfixes.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.