-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql-databases.pl
33 lines (29 loc) · 946 Bytes
/
mysql-databases.pl
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
#!/usr/bin/perl
use DBI;
%params;
@options = qw(user password host);
foreach $key (@options) {
($k) = split(//, $key);
foreach (@ARGV) {
if ((m/^--$key=(.*)$/) || (m/^-$k(.*)$/)) {
$params{$key} = $1;
}
}
}
if (keys %params == 0) {
print "dumps all the databases of a specific server\n";
print "valid options ->\n";
@_ = @options;
@shorts = map { ($_) = split(//, $_); } @_;
@_ = map { sprintf('-%s, --%s', $shorts[$_], $options[$_]) } 0..$#options;
print join("\n", @_);
print "\n";
exit;
}
$dsn = sprintf('dbi:mysql:database=information_schema;host=%s', $params{host});
$dbh = DBI->connect($dsn, $params{user}, $params{password}) ||
die DBI->errstr();
$q = 'select schema_name from schemata where schema_name != "information_schema"';
$argh = $dbh->selectall_arrayref($q, {Slice => {}});
@argh = map { $_->{schema_name} } @{$argh};
print join("\n", @argh) . "\n";