canonical human-readable names of the hosts.

Reformat.

Do not die when finding an InnoDB table, go on to the next database instead.

fact an IP address.

only one single database *instead* of an input file.

Format of arguments (for example):

  --source=ak4_chrysemys_picta_ref@genebuild1
  --target=ak4_test@ens-research


If a special port number needs to be specified:

  --source=ak4_chrysemys_picta_ref@genebuild1:3306
  --target=ak4_test@ens-research:3306

You still need to log in on the destination/target server and run the
script as the mysqlens user.

Do not re-set $executable{$key} = $key when we have worked so hard to
set it to something usable...

Added a section which does checks to make sure we have the executables available & if not then use locate to find alternatives.

Data dir is always set so we need to override if given a target location. Also formatting changes applied

Adding an option to copy to a non standard location for use by teams who do not store their MySQL data in its data directory

to copy.

Add --skip_tables and --only_tables (mutually exclusive) switches.
These both take a comma-delimited list of tables to include/exclude.

Modified code to get engine type from tables using SHOW TABLE STATUS
rather than querying the information_schema.

Minor formatting.

to flush index data to file before copying.

Add new flag:

  --noopt           (Optional)
                    Skip the optimization step.  The database tables are
                    optimized (as with "OPTIMIZE TABLE") to flush the
                    index data onto disk.  This may be a time consuming
                    operation for very large tables.  The --noopt flag
                    disables the optimization.

Do not repair automatically.
Add informationl blurb at end of execution.

does not follow the simple "table_name.{MYI,MYD}" naming scheme.  Make
the script properly handle these anyway.

databases with huge number of tables (mart databases), this would
otherwise fail.

Some smaller fixes too.

$target_db.