#!/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