1月 202013
 

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

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据