perl 备份mysql_执行MySQL数据库备份的Perl脚本

#!/usr/bin/perl

print “Content-type: text/htmlnn”;

$cmd=system “/usr/local/mysql/bin/mysqldump –uu201002 -ppasswd d201002 > perldbbackup.mysl”;

if ($cmd)

{

print “Error!!!!”;

}

else

{print “Sucess!!!!”;

}

数据库备份

#/usr/local/myal/bin/mysqldump -u Username -pPassword databaeID | gzip > /backup/files/databaseID_`date +%m_%d_%y`.gz

计划任务条目

05 1 * * 1 root /usr/local/mysql/bin/mysqldump -u Username -pPassword databaeID | gzip > /backup/files/databaseID_`date +%m_%d_%y`.gz