bitscn.com
shell简单全备mysql脚本案例 [root@cacti mysql]# cat backup.sh #!/bin/sh #created by taiyang#2012-9-16#function:backup mysql database #set local variablesdbname=backupbackuppath=/mysqlbak/mysqlbak/dumpfile=${backuppath}${dbname}`date +%y%m%d_%h%m%s`.bak v_username='root'if [ $v_username != 'root' ];thenecho error:the script must be run as mysqlexit 1fi echo backup database path:$dumpfileecho ------------------------------ dateecho ****************************echo backup database beginecho **************************** mysqldump -uroot -proot --opt $dbname > $dumpfile echo **************************** echo backup database endecho ****************************date #delete backups before 5 daysfind $backuppath -ctime +5 -name '*.bak' -exec rm {} /;[root@cacti mysql]# 从备份脚本当中进行还原数据库的信息;
[root@cacti mysqlbak]# lsbackup120928_114307.bak backup120928_114556.bak cacti120928_105558.bakbackup120928_114309.bak cacti120928_105044.bak cacti120928_110443.bakbackup120928_114310.bak cacti120928_105155.bak cacti120928_110448.bakbackup120928_114311.bak cacti120928_105457.bak cacti120928_110449.bak[root@cacti mysqlbak]# pwd /mysqlbak/mysqlbak[root@cacti mysqlbak]#[root@cacti ~]# mysql -hlocalhost -uroot -proot backup /mysqlbak/backup120928_114556.bak
[root@cacti ~]# mysql -uroot -prootwelcome to the mysql monitor. commands end with ; or /g.your mysql connection id is 860server version: 5.0.22-log type 'help;' or '/h' for help. type '/c' to clear the buffer. mysql> use backupdatabase changedmysql> show tables;+------------------+| tables_in_backup |+------------------+| b | | t | +------------------+2 rows in set (0.00 sec) mysql> exitbye
bitscn.com