DBD::MySQL _ListDBs function for 3.23

I was doing some tests last night and I wanted to compare the databases
on two servers.  First I wanted to ensure that the databases were
defined on both systems and to only transfer those that were not on the
second server from the first server.

Using the following:

$drh = DBI->install_driver("mysql");
@dbs = $drh->func("localhost:3306", '_ListDBs');
@dbs_2 = $drh->func("192.168.0.1:3306", _ListDBs');

print join ", ", @dbs;
print "\n";
print join ", ", @dbs_2;
print "\n";

the result was 2 blank lines.

The POD says that _ListDBs is useful since DBI->data_sources("mysql")
will only show for localhost.  When I replaced the localhost line above
with the data_sources command, it provided the list for the local
system.  I figured that $drh wasn't initialized, but I threw in a
command to see if $drh contained anything, and it was indeed a blessed
reference.  Does anyone know why _ListDBs doesn't work as described in
the POD?
-- 
Mike Ford
Web Developer, WorkFlow Integrators, Inc.
mike@wfiinc.com
www.wfiinc.com

• DBD::MySQL _ListDBs function for 3.23 by Mike Ford
• Re: DBD::MySQL _ListDBs function for 3.23 by Bodo Eing