Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
MySQL::Diff(3)	      User Contributed Perl Documentation	MySQL::Diff(3)

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-2016 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.32.0			  2016-07-21			MySQL::Diff(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | COPYRIGHT AND LICENSE | SEE ALSO | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=MySQL::Diff&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help