bacula remote backup

First, the implementation of local automatic backup database is simple: 1. Log in as Root 2. Scheduled Tasks (3:30 automatic execution/usr/bin/mysqlbackup per day) Crontab 0 3:30 * * */usr/bin/mysqlbackup 3. Write an automatic backup database script Vi/usr/bin/mysqlbackup #!/bin/bash Mv/home/.../db_bak5.tgz/home/.../db_bak6.tgz Mv/home/.../db_bak4.tgz/home/.../db_bak5.tgz Mv/home/.../db_bak3.tgz/home/.../db

Given that the data is backed up on this computer, the data cannot be removed once the machine's hard drive fails. Remote manual backup data is time-consuming, laborious, and timely. The best way to do this is by scripting Remote automated provisioning. However, a password is required for remote access either via SSH o

,download}chmod777/var/ftproot/uploadvsftprun# Client Configuration yum INSTALLNBSP;-YNBSP;FTP#FTP Remote backup file #!/bin/bashhost= "172.16.16.23" id= "Zhang" pw= "password" basedir= "/etc" ip_addr= ' ifconfig|grep ' inet Addr: ' |grep-v ' 127.0.0.1 ' |cut-d:-f2|awk ' {print$1} ' current_date= ' date+%y-%m-%d ' remotedir= "/var/ftproot/upload" backupfile= "' date+%Y- %m-%d '. etc.tar.gz "cd/tmptar-zcvf"

......So the name of the private key and the public key are:Id_rsa_192.168.102.12 and Id_rsa_192.168.102.12.pubThe contents of the Id_rsa_192.168.102.12.pub file are then appended to the sever ~/.ssh/authorized_keys2 file,Finally, specify the local key locally with the-I parameter of the SSH command and log in:# ssh-i/root/.ssh/id_rsa_192.168.102.12 192.168.102.12If the key is set to a password, log in with the key password, without a password, directly logged inThe SCP is the same.Such as:Scp-i

(8),getdate()-4,112)+‘.bak‘‘,no_output‘from master..sysdatabaseswheredbid>4--不备份系统数据库opendatebakfetchnextfromdatebakinto@s,@delwhile@@fetch_status=0beginexec(@del)exec(@s)fetchnextfromdatebakinto@s,@delendclosedatebakdeallocatedatebakgo--删除映射execmaster..xp_cmdshell‘netusew:/delete‘go--用JOB.--SQLSERVER2000为例企业管理器—>数据库服务器—>管理目录—>SQLSERVER代理—>作业—>右键选—>新建常规选项页—>输入作业名称—>选中所有者。步骤选项页—>新建—>输入步骤名—>类型TSQL脚本—>选择需要执行的数据库—>在命令框里输入你的SQL脚本：如：updatetbset状态=...where日期...........你可以点左下角的【分析】按钮，分析一下语法，分析无误，按确定。调度选