#! /usr/bin/perl -w
# db-backup.pl
# Dump and gzip each MySQL database.
use strict;
use DBI;
my $dbhost = "localhost";
my $dbuser = "root";
my $dbpass = "easyONE";
my $date = "`date +%Y-%m-%d`";
my $path = "/your/archive/db";
my $ext = "bz2";
flush_old($path,$ext);
my($dbh,$sth,$query);
my $dsn = "DBI:mysql:host=$dbhost";
$dbh = DBI->connect($dsn,$dbuser,$dbpass,{PrintError => 0, RaiseErr
+or => 1});
$query = qq^SHOW DATABASES^;
$sth = $dbh->prepare($query);
$sth->execute();
while(my $ref = $sth->fetchrow_array()) {
my @bp = `mysqldump --user=$dbuser --password=$dbpass --add-drop-t
+able $ref | bzip2 -1 > $path/$ref.$date.$ext`;
}
$sth->finish();
$dbh->disconnect();
# - - - - - - - - - - - - - - - - -
sub flush_old {
my ($path,$ext) = @_;
opendir BP_DIR,"$path" or die "Cannot open $path: $!\n";
my @old_backups = grep { /\.$ext$/ } readdir BP_DIR;
closedir BP_DIR;
for (@old_backups) {
my @args = ("rm","-f","$path/$_");
system(@args);
}
}
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|