What's New in the MySQL Enterprise Fall 2009 Release? - Interview with Mark Matthews
We talked to Mark Matthews and Andy Bang, two core developers in the MySQL Enterprise Monitor team, to give us some insight into the new features in the latest MySQL Enterprise Release. You can find more about the MySQL Query Analyzer in our previous interview with Mark Matthews.
MySQL::Diff(3pm) User Contributed Perl Documentation MySQL::Diff(3pm)NAME
MySQL::Diff - Generates a database upgrade instruction set
SYNOPSIS
use MySQL::Diff;
my $md = MySQL::Diff->new( %options );
my $db1 = $md->register_db($ARGV[0], 1);
my $db2 = $md->register_db($ARGV[1], 2);
my $diffs = $md->diff();
DESCRIPTION
Generates the SQL instructions required to upgrade the first database to match the second.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
Fuller documentation will appear here in time :)
o register_db($name,$inx)
Reference the database, and setup a connection. The name can be an already existing 'MySQL::Diff::Database' database object. The index
can be '1' or '2', and refers both to the order of the diff, and to the host, port, username and password arguments that have been
supplied.
o db1()
o db2()
Return the first and second databases registered via "register_db()".
o diff()
Performs the diff, returning a string containing the commands needed to change the schema of the first database into that of the
second.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
mysqldiff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff(3pm)