mysql数据备份的脚本分享
本篇内容主要讲解“mysql数据备份的脚本分享”,感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷,实用性强。下面就让小编来带大家学习“mysql数据备份的脚本分享”吧!
#!/usr/bin/perl-wusewarnings;usestrict;useDBI;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(mysqltest);my($sec,$min,$hour,$day,$mon,$year)=localtime;$year+=1900;$mon+=1;my$time_now="$year-$mon-$day";my@backup_list;mkdir"$backup_dir",0755if!-e"$backup_dir";openLOG,">>$backup_log";printLOG"----------------------\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)orprintLOG"Couldnotconnectmysqlserver:".DBI->errstr."\n";foreachmy$db(@backup_db_list){mkdir"$backup_dir/$db",0755if!-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"orprintLOG"mysqldumperror:$!\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>;foreachmy$backup_file(@all_backup_db_list){unlink$backup_fileif(time()-(stat($backup_file))[9]>(60*60*24*5));}}$dbh->disconnect();print"@backup_list\n";my$ftp=Net::FTP->new($ftp_host,debug=>0)orprintLOG"Countnotconnectftp:$ftp_host\n";$ftp->login($ftp_user,$ftp_passwd)orprintLOG"Couldnotloginftp:$ftp_host\n";$ftp->binary();$ftp->cwd($ftp_dir);foreachmy$upload_backdb_file(@backup_list){$ftp->put($upload_backdb_file)orprintLOG"put$upload_backdb_filefaild!\n";}printLOG"------------------------\n---------END----------\n";$ftp->quit;close(LOG);
到此,相信大家对“mysql数据备份的脚本分享”有了更深的了解,不妨来实际操作一番吧!这里是亿速云网站,更多相关内容可以进入相关频道进行查询,关注我们,继续学习!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。