bacula remote backup

This article explains how to extend the stored procedure of SQL Server database through examples to achieve remote backup and recovery.Instance description:Environment: win2k + sqlserver 2 K + query AnalyzerSQL SERVER service instance name: mainserverName of the database to be backed up: msdbLocal Machine name (Client): davidLocal User: zf password 123Local domain: domainFolder for local

-- Backup environment: Back up the database (TEST) of the database server (192.168.1.1) to C $ at the client (192.168.1.107 ). -- First, perform a ing with the client Exec master.. xp_mongoshell 'net use Z: \ 192.168.1.107 \ e $ "password"/User: 192.168.1.107 \ Administrator' -- Note:/*Z: indicates the drive letter of the local machine corresponding to the ing network path, which corresponds to the following

MySQL remote full backup: # Bash/sh! Echo"Start backup ..." # MySQL Info SQL _user = root SQL _psw = root SQL _db = buke_user Name = $ SQL _db $ (date + % y % m % d). SQL Backup_path =/home/backup File = $ SQL _db $ (date has been successfully yundun m1_d1_.tar.gz # Ftp Info Ftp_host = 11.1.1.111 Ftp_use

This paper analyzes the SQL Server database extended stored procedure through an example, and realizes the method and step of remote backup and recovery. Example Description: Environment: Win2k+sqlserver 2k+ Query Analyzer SQL Server Service Instance name: Mainserver Database name to be backed up: msdb Local machine name (client side): David Local User: ZF Password: 123 Local Domain name: domain A folder f

/mysql/bin/mysql-u root-p * * * * * MyBlog This way, I used to be very rarely used now, because it is easy to produce garbled, because:A, when you export the database, if you forget to set the export character sets, when the import, there may be problems.b, if you set the export setting when the UTF8 encoding, but you have your database now the character set is changed to gb2312. This will be garbled.2, using the source statementFor example:Mysql-u dbadmin-pUse MyBlog;Set names UTF8; #这里的字符集根你的将

Tags: this www ase shel path shell. com off mysqld1. Add backupmysqleveryday.sh (vi/data/shell/backupmysqleveryday.sh)#!/bin/sh#this Shell is the user for backup MySQL data everyday#author: www.ieliwb.com#path-configbase_mysql_path=/data/webserver/mysql/mysql_dump_path=/data/mysqlbackup/mnt_back_path=/mnt/web/mysqlbackup/ftp_back_path=mysql_data_backup/#mysql-configMysql_user= "Root"Mysql_pass= "*******"#ftp-configftp_host= "IP"Ftp_user= "********"Ftp

. It's just a word, annoying !!! Synchronization speed is slow !!! Certificate ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Next is the key part of this article: SVN's new image backup solution: SSH + rsync + crontab (Task Plan )) What is SSH? SSH is a more flexible and secure alternative t

Label:Little stuff, for database backup. Retained. #!/bin/SHkeepdays= -currenttime=`Date "+%y-%m-%d-%h-%m"' Backpath="/sql_bak/"DbName="Smdb" Echo${currenttime}/usr/bin/mysqldump--default-character-set utf8-u xxx--password=xxx--database ${dbname} >${backpath}${dbname}.${currenttime}.sql; /usr/bin/SCP${backpath}${dbname}.${currenttime}.sql [email protected]1.2.3.4: ${backpath}${dbname}.${currenttime}.sql; Find${backpath}-name"*.sql"-mtime +${keepdays}-

Synchronize and copy data from a remote Oracle Server to a local backup database Create or replace PROCEDURE "SYNC_DATA_FROM_DBLINK_DB"BEGINDECLARECURSOR c_TabNames ISSelect tname from tab;V_TabName c_TabNames % ROWTYPE;V_ SQL VARCHAR2 (500 );V_rowcount NUMBER;V_rc NUMBER: = 0;V_tab NUMBER: = 0;BEGINDbms_Output.put_line (to_char (SYSDATE, 'yy-mm-dd hh24: mi: ss') | 'start to import the table from a

1, open to be the console, click on the upper left corner to be icon, in the Drop-down menu click Install and License--> on other servers to install agents and Backup Exec server; 2, in the Open Installation Wizard, click Add--> Add a single computer; 3, select the product Agent for Windows to install; 4, the installation of the screen prompts, enter the name of the target server, as well as its loca

@statement = N ' CREATE proc [dbo]. [Backsqlorfile] @ServerIp varchar,--database server IP @ServerName varchar,--Database computer users @ServerPwd varchar,--database Computer User password @ServerIISIp varchar,--IIS Server IP @ServerIIsName varchar,--IIS server name @ServerIIsPwd varchar,--IIS Server password @SqlShareFile varchar,--remote SQL shared files @IIsShareFile varchar,--remote IIS s

installation. You need to open it in the/etc/default/rsync file. This file is a Debian-specific setting that is used to set whether rsync runs in service mode and configures service ports [can be changed, default is 873], and IP addresses. Only the server side (222.222.222.222) on the line, the client does not have to open. #vi/etc/default/rsync Will be the original: Rsync_enable=false To rsync_enable=true The others don't have to be more. Save exit Second, set up the configuration f

Tags: des blog http io ar os using SP filesOriginal: SQL remote backupSet ANSI_NULLS ONset quoted_identifier ongo--=============================================--author:dcrenl-- Create date:2013-9-5 9:54:46--description:web Server Remote Backup Database,--This method requires the sharing feature of the Web server to be turned on.--authentication method in the sam

mode, plus the control switch passive mode to see the situation plus if the upload using passive mode Entering Passive Mode errorBinary: Binary transferCD: Server side CD LCD: Client CD put upload single mput upload multiple get download single mget download multiple Prompt Multiple Tips#========================start Shell Script ============================#!/bin/bash#定义备份数据库时使用的用户名和密码db_user = "root" db_passwd= "111111"#定义FTP服务器地址, user name, password, directory ftp_url=113.108.8.80ftp_user=f

Tags: style io ar os for SP file Data divI. Implementing SSH remote LoginMachine Environment:192.167.33.108 clent User: Crawler192.167.33.77 Server User: Crawler1. Client- generated key/home/crawler/.ssh/ssh-keygen2. View Key file permissionsLs-ld ~/.ssh; Ls-l ~/.ssh3. Modify File Permissionschmod 700/home/crawler/.sshchmod 600/home/crawler/. SSH/id_rsa4. Copy the public key to the server sideScp-r /home/crawler/. SSH/id_rsa.pub [email protected]:/hom

}-p {3}--authenticationdatabase admin-o {4} AMP;AMP;CD {5} zip- R {6}/{7} {8}/* '. Format (db_host,db_port,db_user,db_pass,tmp_dir,tmp_dir,back_dir,tar_bak,tmp_dir), Shell=True, Stdin=subprocess. Pipe,stdout=subprocess. PiPE, Stderr=subprocess. PIPE) Print (' This time {ip}mongodb backup successfully executed '). Format (ip=db_host) time.sleep (0.5) Shutil.rmtree (Tmp_dir) exce PT Exception as E:print (' Backup