Synchronize and copy data from a remote Oracle Server to the local backup database createorreplacePROCEDURESYNC_DATA_FROM_DBLINK_DBASBEGINDECLARECU
Synchronize and copy data from a remote Oracle Server to the local backup database create or replace PROCEDURE SYNC_DATA_FROM_DBLINK_DB ASBEGIN DECLARE CU
Synchronize
Tags: sudo. SQL backup Data Body Test one tab localhost1. First create a local database (for backup).Log in to MySQLsudo mysql-u root-p rootCreate DATABASE test; The test here is the same name as the remote database.2. Back up the remote database to a local testbackup.sqlMysqldump-h 172.26.100.145-uroot-proot Test--DEF
sohu.
Click the http://mirrors.sohu.com/help/ubuntu.html page to see the Ubuntu Source server help.
You can directly modify/etc/apt/sources. list file, add the sohu source server to use the sohu source server, which is much faster than the international official ubuntu source server.
Next, I will build a local Ubuntu Source server based on sohu's Ubuntu Source server.
Why I chose sohu's Ubuntu Source server as the source for replication:
1. sohu's Ub
Build a local Ubuntu backup storage. requirement analysis recently, the company's software Team has the following requirement: can we build an Ubuntu image server on the LAN? the advantage of this is that it can save the installation time of some commonly used Ubuntu tools. II. deployment process 2. 1... build a local Ubuntu
Tags: work www. Tar mysql firewall logs mysq * * * Cannot access"Ready to Work"
Build FTP server: Windows server R2 Build FTP service
If the native Access report 530 error: 1, check the user name, password, 2, check the FTP directory user rights.
If the remote host is inaccessible, check the firewall.
The port for ftp: The control port is 21, the data port is 20 under active mode (port), and the passive mode (PASV) is uncertain.
"Not to be continued ..."Walker * * *Python3
Server
/* data stored in storage process * *
/* Support from the data from the service device to the local machine * *
--Author: Yoncen
CREATE PROCEDURE Up_dbbackup
(
@backup_db_name VARCHAR (128),
@filename VARCHAR (128),/* Backup path + filename * *
@flag VARCHAR () OUTPUT
)
As
SET NOCOUNT on
DECLARE @sql NVARCHAR (4000), @par NVARCHAR (1000)
IF not EXISTS (
SELECT * FROM Master. sysdatabases
WHERE name=
on the web said that only with git commit this is not the case can be such a command system will automatically use a default application The program opens a file for you to enter a description, but if the system does not open by default, then you can not continue to carry out, anyway, is to write instructions, it is not a few words, suggest that you directly write the order, province to their own trouble(5) Git Remote add origin https://github.com/test/testt.git//Here say two places of origin t
1. Determine the log file name and path of the online server2, a local server can connect the public network, create a log account, set the password3, the online server requirements: A. Determine if the Sshpass package is installed[Email protected] sh]# Rpm-qa|grep SshpassSshpass-1.06-1.el7.x86_64Install Yum install-y if not present Sshpassb, Write script transferSuch as:[email protected] ~]# cat logbak.sh#!/bin/bashcd/opt/soft/spring-cloud/member-907
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 remote T
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.