建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
mysql數(shù)據(jù)備份的腳本分享-創(chuàng)新互聯(lián)
本篇內(nèi)容主要講解“mysql數(shù)據(jù)備份的腳本分享”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學(xué)習(xí)“mysql數(shù)據(jù)備份的腳本分享”吧!
#!/usr/bin/perl -w
use warnings;
use strict;
use DBI;
my $backup_dir = "/root/perl/backup";
my $backup_log = "$backup_dir/backup_log";
my $db_name = "mysql";
my $db_host = "localhost";
my $db_user = "root";
my $db_passwd = "redhat";
my $db_port = "3306";
my $mysql_bin_dir = "/usr/local/mysql/bin";
my $ftp_user = "ftp";
my $ftp_passwd = "redhat";
my $ftp_host = "192.168.1.100";
my $ftp_dir ="pub";
my @backup_db_list = qw(mysql test);
my ($sec,$min,$hour,$day,$mon,$year)=localtime;
$year += 1900;
$mon += 1;
my $time_now = "$year-$mon-$day";
my @backup_list;
mkdir "$backup_dir",0755 if !-e "$backup_dir";
open LOG,">>$backup_log";
print LOG "----------------------\nStart: $time_now\n";
my $dsn = "DBI:mysql:$db_name:$db_host:$db_port";
my %conn_attrs = (
PrintError => 1,
RaiseError => 1,
AutoCommit => 1,);
my $dbh=DBI->connect($dsn,$db_user,$db_passwd,\%conn_attrs) or print LOG "Could not connect mysql server:".DBI->errstr."\n";
foreach my $db (@backup_db_list){
mkdir "$backup_dir/$db",0755 if !-e "$backup_dir/$db";
chdir "$backup_dir/$db";
my $backup_db_name = "${db}_${time_now}\.sql";
!system "$mysql_bin_dir/mysqldump -h $db_host -u $db_user -p$db_passwd -P $db_port -B $db > $backup_db_name" or print LOG "mysqldump error:$!\n";
system "(tar -zcvf $backup_db_name\.tar\.gz $backup_db_name) 2>&1 >/dev/null" if -e $backup_db_name;
unlink "$backup_db_name" if -e "$backup_db_name\.tar\.gz";
push (@backup_list,"$backup_dir/$db/$backup_db_name\.tar\.gz");
my @all_backup_db_list = <*.*.tar.gz>;
foreach my $backup_file (@all_backup_db_list){
unlink $backup_file if (time() - (stat($backup_file))[9] > (60*60*24*5));
}
}
$dbh->disconnect();
print "@backup_list\n";
my $ftp = Net::FTP->new($ftp_host,debug => 0) or print LOG "Count not connect ftp:$ftp_host\n";
$ftp->login($ftp_user,$ftp_passwd) or print LOG "Could not login ftp:$ftp_host\n";
$ftp->binary();
$ftp->cwd($ftp_dir);
foreach my $upload_backdb_file (@backup_list){
$ftp->put($upload_backdb_file) or print LOG "put $upload_backdb_file faild!\n";
}
print LOG "------------------------\n---------END----------\n";
$ftp->quit;
close(LOG);到此，相信大家對“mysql數(shù)據(jù)備份的腳本分享”有了更深的了解，不妨來實際操作一番吧！這里是創(chuàng)新互聯(lián)建站，更多相關(guān)內(nèi)容可以進入相關(guān)頻道進行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！
當(dāng)前標題：mysql數(shù)據(jù)備份的腳本分享-創(chuàng)新互聯(lián)
地址分享：http://www.dlmjj.cn/article/ddghpd.html
