MySQL备份脚本
时间:2008-12-26 来源:admin126com
MySQL备份脚本
ns1# more data_daily
#!/bin/sh
# -----------------------------------------------------------------------------
# Title: MYSQL Backup daily
# Description: The MYSQL dump utilities are used to perform logical database backup and recovery.
# They are also used to move MYSQL data from one machine or database to another.
# Copyright: Copyright (c) 2001
# author Zhou Lifeng
# version 1.0
# Location: Zhou Lifeng /bak/dnsbak/data_daily
# -----------------------------------------------------------------------------
filename=`date '+%Y%m%d%H%M%S'` /apps/mysql/bin/mysqldump --user=dns --password=xxx dns > /bak/dnsbak/dbdata/dns_$filename.sql exit 0
#!/bin/sh
# -----------------------------------------------------------------------------
# Title: MYSQL Backup daily
# Description: The MYSQL dump utilities are used to perform logical database backup and recovery.
# They are also used to move MYSQL data from one machine or database to another.
# Copyright: Copyright (c) 2001
# author Zhou Lifeng
# version 1.0
# Location: Zhou Lifeng /bak/dnsbak/data_daily
# -----------------------------------------------------------------------------
filename=`date '+%Y%m%d%H%M%S'` /apps/mysql/bin/mysqldump --user=dns --password=xxx dns > /bak/dnsbak/dbdata/dns_$filename.sql exit 0
相关阅读 更多 +