<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Arial; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; "><div><font class="Apple-style-span" face="Arial">Try using the INFORMATION SCHEMA database:</font></div><div><font class="Apple-style-span" face="Arial"><br></font></div><div><font class="Apple-style-span" face="Arial">m</font><span style="font-family: Arial; font-size: medium; ">y $dbh = DBI->connect( "DBI:mysql:information_schema;192.168.0.1", $usrr, $passw, { RaiseError => 3 } );</span><font class="Apple-style-span" face="Arial"><br></font><font class="Apple-style-span" face="Arial"><br>-Don</font></div><div><font class="Apple-style-span" face="Arial"><br class="Apple-interchange-newline">--</font></div><div><font class="Apple-style-span" face="Arial">Don Drake</font></div><div><font class="Apple-style-span" face="Arial"><a href="http://www.drakeconsulting.com">www.drakeconsulting.com</a></font></div><div><font class="Apple-style-span" face="Arial"><a href="http://www.maillaunder.com">www.maillaunder.com</a></font></div><div><font class="Apple-style-span" face="Arial">312-560-1574</font></div><div><font class="Apple-style-span" face="Arial">800-733-2143</font></div></span></span>
</div>
<br><div><div>On Apr 2, 2013, at 12:51 PM, Richard Reina <<a href="mailto:richard@rushlogistics.com">richard@rushlogistics.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">use DBI;<br>my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, { RaiseError => 3 } );<br>my $dbs = $dbh->selectcol_arrayref("show databases");<br><br>my $dbs = $dbh->selectcol_arrayref('show databases');<br><br>print "@$dbs\n";<br><br>When I query the server for a list of databases with the code above it returns the name of just two and there are over 10.<br><br>Any ideas?<br><br>Thanks<br>-- <br>Richard Reina<br>Rush Logistics, Inc.<br>Watch our 3 minute movie: <br><a href="http://www.rushlogistics.com/movie">http://www.rushlogistics.com/movie</a><br><br>_______________________________________________<br>Chicago-talk mailing list<br>Chicago-talk@pm.org<br>http://mail.pm.org/mailman/listinfo/chicago-talk<br></blockquote></div><br></body></html>